Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    16

    Unanswered: Function to Prefix Escape character to special charcater

    I need a user defined function which accepts string and escape character and processes the string for prefixing the special character with escape character and returns it.

    Please anyone help me in this.

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Can you give us a few examples of what strings that function would receive and what strings it should return?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Oct 2009
    Posts
    16
    Sample String : "Test\_%$Sample"
    Escape Character : "\"

    Expected String result :"Test\\\_\%\$Sample"

Tags for this Thread

Posting Permissions

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