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