Determine if a field contains a number

[markusj]

Hi, I am trying to retrieve information from a field where the field can contain both a number for one record and a string for another record. The field is set as a string in the database schema.

What I would like to do is retrieve only those fields which do not contain a number. In VB I would call the isNumeric() function to return true or false.

How can I do this in SQL?

eg..
SELECT user_name FROM users WHERE user_name [is not numeric]

Thanks in advance
MarkusJ

 

[cmmrfrds]

SELECT user_name FROM users
WHERE isnumeric(user_name) = 0