Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    83

    Question Unanswered: can i use "translate" in sql server,is it a keyword

    im trying to find the equivalent of the below oracle code in sql server.But to my knowledge i feel "translate "is not supported by sql server. so please send me the equivalent sql server query for this.

    SELECT 'http://ploft.com/ploft?y='||translate(comp,' ','+')||',+'||translate(california,'
    ','+')||',+'||ca||'+'||pz
    INTO :ls_MAP FROM project WHERE portno=:dbno;
    Last edited by krReddy; 10-03-06 at 12:12.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I believe the REPLACE function is what you are after in SQL Server.

  3. #3
    Join Date
    Oct 2006
    Posts
    83
    thank you crowley

    how to use 'replace' function to change the characters in a given column.In oracle we can do that (its in above query)

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    http://msdn.microsoft.com/library/en...asp?frame=true

    Code:
    replace (query, 'TRANSLATE', 'REPLACE')

Posting Permissions

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