Question

What is difference between STUFF and REPLACE in SQL Server?

Answer

REPLACE is used to replace all the occurances of the given pattern in a string.

Example: select Replace('Nirav','N','R')

O/P: Rirav

STUFF: This function is used to replace the part of string with some other string.

syntax: STUFF (stringexpression, start, length, replacementcharacters)

Example:SELECT STUFF('Nirav''s Blog is USEFUL',9,4,'DATABASE')

Output: Nirav's DATABASE is USEFUL

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·