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
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With