Validating a numeric value in the + SQL Server field

Question

What will be the most efficient way to check the numbers in a field that will contain several letters? I would like to do this if a where clause is possible.

The data looks something like this:

3833N4323 32N907654 5W5840904

Answer 1

Checking at least one number in a field (fixed):

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

Checking only the numbers in the field:

WHERE ISNUMERIC(field) = 1

Answer 2

A simple LIKE to find any number would be enough ...

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

Answer 3

select ISNUMERIC(data)