Checking for numeric value in field + SQL Server
sql-server
Solution
Checking for at least one number in a field (corrected):
WHERE PATINDEX('%[0-9]%', field) != 0
Checking for only numbers in a field:
WHERE TRY_CONVERT(field AS int) IS NOT NULL
Problem
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