Monday, January 31, 2005

SQL recursive REPLACE command

SQL recursive REPLACE command: "REPLACE(SourceString, FindString, NewString) where SourceString is the string to search, FindSting is the string you want to replace and NewString is the string you want to put in the place of FindString.
This function is recursive so it will replace all occurrences of FindString within SourceString. The function will accommodate any string size up to 2000 characters. "

No comments:

Post a Comment