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]
