Using SUBSTRING and CHARINDEX function in Select query in SQL Server

Hi PRA,

Refer the below sample query.

DECLARE @Test AS TABLE(Id INT IDENTITY,Address VARCHAR(10))
INSERT INTO @Test VALUES('1-20/1')
INSERT INTO @Test VALUES('1-20/2')
INSERT INTO @Test VALUES('2-21/2')
INSERT INTO @Test VALUES('3-22/5')
SELECT Id,SUBSTRING(Address,(CHARINDEX('-',Address) + 1),(LEN(Address))) 'Address' FROM @Test

Output