Select Query Help!!

From: Alex King <alexkingjr_at_yahoo.com>
Date: 8 Dec 2003 21:40:53 -0800
Message-ID: <4dedbd10.0312082140.2b1a4a06@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 Mon Dec 08 2003 - 23:40:53 CST