SQL Server 的Indexof

 

dECLARE @Name NVARCHAR (50)
SET @Name = '1234567890ABCDEFG.HI.JKLMNOPQRSTUVWXYZTest'

DECLARE @Position INT

--sql first indexof
SET @Position = CHARINDEX('.', @Name);
select @Position

SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position)

--sql last indexof
SET @Position =  LEN(@Name) - CHARINDEX('.', REVERSE(@Name)) + 1
SELECT SUBSTRING (@Name, @Position+1,LEN(@Name)-@Position)