sql-server - 确定列值字符串是否以数字开头

Question

我有一个表问题，其中有一列描述。它的列值是这样的:

This is First Heading, 
1 This is Subheading one, 
1.2 This is subheading Question
This is Second heading
2 This is subheading Two.
2.1 This is Subheading Question1

如何确定每一行的列值是否以数字 0-9 开头？

Answer 1

SELECT CASE WHEN ISNUMERIC(SUBSTRING(LTRIM(Description), 1, 1)) = 1 
         THEN 'yes' 
         ELSE 'no' 
       END AS StartsWithNumber
FROM Questions 

• ISNUMERIC
• SUBSTRING