Loading

Start Index of In SQL

ankit srivastava

8y990

declare @uname nvarchar(500)

set @uname='(123456) ANKIT SRIVASTAVA'

Desired OUTPUT

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Kiran Chanduri8y ago
Hi Srivastava ,

following code will give the required result.
select @uname,SubString(@uname,Charindex('(',@uname)+1,Charindex(')',@uname)-2)
0
ankit srivastava8y ago
select @uname,replace(replace(SUBSTRING(@uname,CHARINDEX('(', @uname), CHARINDEX(')', @uname)),'(',''),')','')
0