Friday, June 26, 2009

STUFF in Sql Server 2005

SELECT STUFF('gangadhar', 2, 3, '12345')
The following example returns a character string created by deleting three characters from the first string, gangadhar, starting at position 2, at a, and inserting the second string at the deletion point.
Output :
g12345adhar

No comments: