At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric. For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more digits followed by a space? If so, field REGEXP '^[0-9]+ ' should work.
Yeah that will do it nicely.
It would still be good to have an isnumeric() function aliased to something like this, but anyway it solves my problem.
Thanks!
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
