Code Snippet posted by:
Itsmemohanr | Posted on: 8/22/2012 | Category:
SQL Server Codes | Views: 503 | Status:
[Member] |
Points: 40
|
Alert Moderator
DECLARE @string VARCHAR(50)
SET @string = 'This is mohan from IT'
LEN
PRINT len(@string)
CHARINDEX
PRINT charindex('is', @string) -- 1
PATINDEX
PRINT patindex('%m___n%', @string)
STUFF
PRINT stuff(@string, 6, 2, 'xx')
R.Mohan
Flextronics
Found interesting? Add this to: