sqlserver 查询字段数据是否是数字

ISNUMERIC 函数

 

select * from H3_ReportUserData where  fartherTitleId ='H3_fartherTitleId_5' 

and ISNUMERIC(choice) = 0