sql 中的 indexOf 与 lastIndexOf DECLARE @Name NVARCHAR (50) SET @Name = ‘12345.67890ABCDE.FGHIJKLMNOPQRSTUVWXYZTest’ DECLARE @Position INT –sql first indexof SET @Position = CHARINDEX(‘.’, @Name); SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position) –sql last indexof SET @Position = LEN(@Name) – CHARINDEX(‘.’, REVERSE(@Name)) + 1 SELECT SUBSTRING (@Name, 0, @Position)