InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:59:41 GMT20http://www.sqlservercentral.com/Forums/Topic944345-145-1.aspxMy 2 cents :-)[code="sql"]declare @table table(string varchar(50))insert @table (string)select '[gdhdnuidd] 1st Party SW'union all select '[abcdef] Client'union all select 'testbusiness'select case when charindex(']',string) > 0 then right (string, (len(string)- charindex(']',string))) else string end finalstringfrom @table[/code]Mon, 28 Jun 2010 22:59:50 GMTColdCoffeehttp://www.sqlservercentral.com/Forums/Topic944345-145-1.aspxHow does this work?[code="sql"]declare @test table (Col1 varchar(50))insert into @testselect '[abcdef] Client' UNION ALLselect '[gdhdnuidd] 1st Party SW' UNION ALLselect 'testbusiness' select case when charindex(']', Col1) > 0 then substring(Col1, Charindex(']', Col1)+2, 50) else Col1 end from @test[/code]Mon, 28 Jun 2010 22:13:15 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic944345-145-1.aspxI have a SP which gets parameter @business like this[abcdef] Client[gdhdnuidd] 1st Party SWtestbusinessI want to get rid of the charcters from [ and ]. Is there a SQL function which searches for the open bracket[ and closing bracket ] and remove the whole set of characters.Is it possible. Appreciate your help on this,.The end result i want should be like thisClient1st Party SWtestbusinessBasically i want to remove the characters inside the brackets and the bracket too..--SamMon, 28 Jun 2010 19:13:59 GMTsammm