sqlserver 判断字段是否是纯数字

PATINDEX('%[^0-9|.|-|+]%',w.waterMeterNo)=0

如 

SELECT 
 w.*

FROM [dbo].[waterMeterInfo] w

where  isnull(w.collectionStatus,'')='1' and  PATINDEX('%[^0-9|.|-|+]%',w.waterMeterNo)=0