Eugene Elutin (7/25/2013)
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.
i might have misread this, i thought he wanted to return a 1 /-1 flag ,but also definitely misread integer to be is kinda sorta numeric, so i thought that one might hit the sweet spot.
Lowell