isnum/isalpha

[hyuan]

Is there any way to verify a varchar field to be all numeric?

I was thinking along the lines of a function similar to isnum or isalpha in C/Java, but have had no luck thus far in locating one in SQL or Sybase functions.

Or perhaps verifying a numeric field may be done another way.

Thanks in advance for any help

Howard

 

[dbmsguy]

try this:

select xxxx from table where patindex("[a-z]",colname) > 0

Paul

http://www.dbmsguy.com