Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    49

    Unanswered: 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...
    MCSD .NET, SCJP, SCJWD

  2. #2
    Join Date
    Oct 2003
    Posts
    84
    In TSQL you would use

    REPLACE(StringToSearch, OldString, NewString);

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

  3. #3
    Join Date
    Apr 2004
    Posts
    49
    thanks...^^
    MCSD .NET, SCJP, SCJWD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •