Replacing all text within brackets or any other special character by MS SQL Query

Keep all data in left side before starting a string with brackets and  Replace or remove other data in right side.

declare @str varchar(100)
set @str=' Rakesh Dhiman, Vishnu Nagar (Jagadhri W/Shop) Yamunanagar '
select left(@str, charindex('(', @str)-1)

Final Result- Rakesh Dhiman, Vishnu Nagar 

Keep all data in right side before starting a string with brakets and  Replace or remove other data in left side.

declare @str varchar(100)
set @str='Rakesh Dhiman, Vishnu Nagar (Jagadhri W/Shop) Yamunanagar '
select right(@str, charindex(')', reverse(@str))-1)

Final Result- Yamunanagar


 

Related Alrticles

FREE!!! Registration