determine if column value string starts with a number
SELECT * FROM Questions WHERE Description LIKE '[0-9]%'
SELECT CASE WHEN ISNUMERIC(SUBSTRING(LTRIM(Description), 1, 1)) = 1
THEN 'yes'
ELSE 'no'
END AS StartsWithNumber
FROM Questions
- ISNUMERIC
- SUBSTRING