asked on

SQL test if field is numeric

guys how do i test if a field value is numeric using an SQL way?

i can simply do isnumeric but that isn't very fast cause it's calling VBA functions.

thanks guys!! = ))

magento

How about a regex..?

http://dev.mysql.com/doc/refman/5.1/en/regexp.html

SELECT * FROM myTable WHERE col1 REGEXP '[0-9]+';

Thanks,
Magento

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

developingprogrammer

ASKER

i see cool thanks angelIII and gustav!

hrmm i think all my questions lead to the same solution source - which is where do i get the documentation for all the Access SQL functions? i can find the documentation for T-SQL but not for Access-SQL and i think they're slightly diffferent

developingprogrammer

ASKER

guy the question in my previous comment is pending an conclusion from my other questions as well. once i get the conclusion from the other questions i'll post it here too. thanks!! = ))

developingprogrammer

ASKER

ok guys the conclusion from everyone who's participated in all my other questions linked to this topic is....... TA DA! THERE IS NO SPECIFIC DOCUMENTATION FOR JET SQL FUNCTIONS! so make merry and be happy!! hahaha = ))