Difference between STUFF and REPLACE
STUFF function is used to overwrite existing
characters using this syntax: STUFF (string_expression, start, length,
replacement_characters), where string_expression is the string that will have
characters substituted, start is the starting position, length is the number of
characters in the string that are substituted, and replacement_characters are
the new characters interjected into the string.
REPLACE function is used to replace existing
characters of all occurrences. Using the syntax REPLACE (string_expression,
search_string, replacement_string), every incidence of search_string found in
the string_expression will be replaced with replacement string
No comments:
Post a Comment