Checking for numeric value in field + SQL Server

Question

Hey Everyone,

What would be the most efficient way to check for numbers in a field that would contain a few letters? I would like to do this if the where statement as possible.

The data would look something like this:

3833N4323 32N907654 5W5840904

Answer 1

select ISNUMERIC(data)

Answer 2

Checking for at least one number in a field (corrected):

WHERE PATINDEX('%[0-9]%', field) != 0

Checking for only numbers in a field:

WHERE ISNUMERIC(field)

Answer 3

A simple LIKE to find any number will suffice...

...WHERE LIKE '%[0-9]%'