SQL Server 2000/5 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'

Answer 1

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'

Answer 2

Thank you. That worked :)