Lowell (7/25/2013)
doh!, if it ends in [0-9] might be even easier?
SELECT *,
CASE
WHEN x LIKE '%[0-9]'
THEN 1
ELSE -1
END
from tmp
that will return 1 for union select x = 'some text-321'
I thought OP wanted first digit.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]