tags:

views:

1408

answers:

2

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'
+10  A: 

T-SQL Reference for LIKE for SQL Server 2000:

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 table shows several examples of using the LIKE keyword and the [ ] wildcard characters.

For your case:

... LIKE '%[_]d'
Lasse V. Karlsen
A: 

Thank you. That worked :)

GateKiller