1.CHARINDEX (' A ', ' VALUE ') result:2 Style:patindex (Varchar,varchar)
Explanation: A in the position order of the string value.
2.PATINDEX ('%a% ', ' VALUE ') result:2 style:patindex ('%xx% ', varchar)
Explanation: A in the position order of the string value.
3.LEFT (' VALUE ', 3) result:val Style:left (Varchar,int)
Explanation: Take 3 characters from value left to right.
4.SUBSTRING (' VALUE ', 2,3) Result:alu style:substring (Varchar,int,int)
Explanation: Take 3 characters from the value 2nd character position, right.
5.STUFF (' VALUE ', 2,3, ' OO ') Result:vooe Style:stuff (Varchar,int,int,varchar)
Explanation: Delete 3 characters from the value 2nd character position and occupy the deleted space with ' OO '.
6.REPLACE (' Value-value ', ' ALU ', ' OO ') Result:vooe-vooe style:replace (Varchar,varchar,varchar)
Explanation: Find all the string/character fragments that exist ' alu ' from value and replace ' alu ' with ' OO '.
SQL Server character manipulation