XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Dear SQLers:   
      
        Does SQL Server have any string escape characters besides   
   doubling of quotation marks as in   
             'This is a single quotation mark('').'   
             "This is a double quotation mark("")."   
   I will have text which could contain both.   
      
        While I am at it, I want to handle any other special character   
   sequences.   
      
        I am referring to plain string values as would be stored in a   
   column, not LIKE strings, etc.   
      
        Why, yes, I am sanitising input.  It is from a Web browser so I   
   do not see how I can avoid using sanitising.  If there is such a   
   solution, please let me know.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)