select your_column_name from your_table_name
where (substr(your_column_name,5,6) ) < 070000
"Alex King" <alexkingjr_at_yahoo.com> wrote in message
news:4dedbd10.0312082140.2b1a4a06_at_posting.google.com...
> I am new to RDBMS world.
> I am currently working on a .Net & oracle 9i application in which I
> have to display certificate numbers based on the last 6 digits. If the
> last 6 digits are less than 070000 then display the data otherwise
> don't.
>
> For example the CertID is the primary key and consists of Year + Cert
> Number( 4 digits of year 2003 & 6 digits of Cert Num 001234 will make
> a 10 digit key of 2004001234).
>
> So if in the database I have following records;
> 2004000200
> 2004054000
> 2004088444
> 2003067122
> 2003090300
>
> Then display only following records;
>
> 2004000200
> 2004054000
> 2003067122
>
> My problem is how to write this SQL Query. Are there any built in
> oracle functions that I could use?
>
> Any suggestions?
> Thanks in advance.
>
> Alex
Received on Tue Dec 09 2003 - 12:31:12 CST
