I have a SP which gets parameter @business like this
[gdhdnuidd] 1st Party SW
I 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 this
1st Party SW
Basically i want to remove the characters inside the brackets and the bracket too..