SQL Server Escape an Underscore

Question

How do I escape the underscore character   I am writing something like the following where clause and want to be able to find actual entries with  d at the end   Where Username Like    d

User · Answer

I had a similar issue using like pattern '%_%' did not work - as the question indicates :-)

Using '%\_%' did not work either as this first \ is interpreted "before the like".

Using '%\\_%' works. The \\ (double backslash) is first converted to single \ (backslash) and then used in the like pattern.

User · Answer

These solutions totally make sense  Unfortunately  neither worked for me as expected  Instead of trying to hassle with it  I went with a work around   select   from information schema columns  where replace table name          not like       order by table name

User · Answer

like          Add     did the job for me

User · Answer

This worked for me  just use the escape

User · Answer

T-SQL Reference for LIKE      You can use the wildcard pattern matching characters as literal characters  To use a wildcard character as a literal character  enclose the wildcard character in brackets  The following table shows several examples of using the LIKE keyword and the     wildcard characters    For your case       LIKE      d

User · Answer

Obviously  Lasse solution is right  but there s another way to solve your problem  T-SQL operator LIKE defines the optional ESCAPE clause  that lets you declare a character which will escape the next character into the pattern   For your case  the following WHERE clauses are equivalent   WHERE username LIKE      d              --  Lasse solution WHERE username LIKE     d  ESCAPE      WHERE username LIKE     d  ESCAPE

User · Answer

None of these worked for me in SSIS v18 0  so I would up doing something like this  WHERE CHARINDEX      thingyoursearching   lt  1  where I am trying to ignore strings with an underscore in them  If you want to find things that have an underscore  just flip it around  WHERE CHARINDEX      thingyoursearching   gt  0

[sql-server] SQL Server Escape an Underscore

Examples related to sql-server