I have a select statement where I want to only return results where the job_code, varchar2(10) is a number
Example: gv123 he32134 bc4543 6785 4320 0323 I only want the ones that are all numbers, no conversion, just return the rows where the job_code is a number. So I would get back from my select the following results 6785 4320 0323 -Sean McCarthy ---------------------- Webmaster - HealthObjects [EMAIL PROTECTED] 410 895 0379 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
