Searching for a letter in a number string

[bessebo]

We occasionally have invalid serial numbers with letters contained within a numeric string. I want to be able to select out serial numbers that have a letter somewhere within the numeric string without having to do the following:

select * from inventory where serialnumber like '%A%' or serialnumber like '%B%'...

all the way through the alphabet. I think I've seen somewhere where you could put A..Z within the select statement somewhere. Is there an easy way to do what I want to do?

Regards,
Bessebo

 

[aalmeida]

You could try to use this:
select * from inventory where ISNUMERIC ( serialnumber ) = 0 -- This will return when it is a invalid numeric

and the following:

select * from inventory where ISNUMERIC ( serialnumber ) = 1 -- thei will return when it is a valid numeric

Let me know AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"