We help IT Professionals succeed at work.

RegEx in Stored Proc

Hi,

Is it possible to modify a string (remove a comma in this case) from within a stored proc?
So, if I have  @string and I want to remove any commas that might exist in @string, how would I do it?
Thanks,
nacht
Comment
Watch Question

In simple, you can use replace function to this task

SELECT REPLACE(@string,',','')

ex:  SELECT REPLACE('a,b,c',',','')

also you can go with regex, check the below link
http://forums.asp.net/t/1418201.aspx/1