Tuesday, February 14, 2012

Does t-sql has Replace(in vb) function?

I want to perform Replace(searchstring, oldstring, newstring) like function in T-sql as same as in VB..
is there existing one or any other user-defined function?
thanks...In TSQL you would use

REPLACE(StringToSearch, OldString, NewString);

All three parameters can be a string or BINARY data...
case insensitive for strings.|||thanks...^^

No comments:

Post a Comment