You could try selecting where Age is greater than 0 .. That should give you a number (in theory not tried it)
The RegExp one will work too (but can be a little 'expensive' if you are doing a lot of queries. e.g. SELECT * FROM Ages WHERE Age 0 > 0; Regards Stephen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 August 2004 14:56 To: [EMAIL PROTECTED] Subject: [ cf-dev ] MySQL Select Numeric Any way in MySQL to select rows where a value is or can be converted to a number? sort of like: SELECT Age FROM Ages WHERE IsNumeric(Age) My best workaround so far seems to be just do the select as normal, then loop through the list, removing rows where "NOT IsNumeric(query.Age)". -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
