DECLARE @a nvarchar(20)
SET @a = '10,234.00'
SELECT CHARINDEX('.',@a)
SELECT CHARINDEX('?',@a)
结果
-----------
7
(1 row(s) affected)
-----------
0
(1 row(s) affected)
DECLARE @a nvarchar(20)
SET @a = '10,234.00'
SELECT CHARINDEX('.',@a)
SELECT CHARINDEX('?',@a)
结果
-----------
7
(1 row(s) affected)
-----------
0
(1 row(s) affected)