select *
from sometable
where substr(somecolumn,1,1) BETWEEN '0' AND '9'
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Sean McCarthy [mailto:SMcCarthy@;HealthObjects.com]
Sent: Monday, November 11, 2002 2:07 PM
To: CF-Talk
Subject: sql isNumeric -- Oracle
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
