Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    84

    Question Unanswered: SQL Like Clause: How to escape wild char

    Dear All,

    Could anyone advise me how to escape the wild card chars in a SQL
    LIKE clause?

    For example, I want to select a company names containing a substring
    "C_C" (or "C%C"). How to escape _ and %, which are the wild cards in LIKE clause?

    Thanks.

  2. #2
    Join Date
    Apr 2002
    Posts
    18
    like ‘%\_name’ escape \

    Matches all strings of the form <anything>_name

Posting Permissions

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