Sample Text

Unordered List

Wednesday, 10 December 2014

CHARINDEX - Searches an expression for another expression and returns its starting position if found.

DECLARE @FullName VARCHAR(100)

SET @FullName ='Clark Kent'

selectCHARINDEX(' ', @FullName)
Output – 6

STUFF -The STUFF function inserts a string into
another string. It deletes a specified length of characters in the first string
at the start position and then inserts the second string into the first string
at the start position.--Syntax STUFF(character_expression , start , length ,
replaceWith_expression)