Is it possible to search for a row or rows with particular strings containing an underscore?
Suppose I have various email addresses all containing an underscore like firstname.lastname@example.org, hj_bus@ where.com, etc.How can I search for those particular emails?
If I use a WHERE clause such as 'WHERE eMail LIKE '%_' it returns all rows. 'WHERE eMail LIKE 'gm_%' returns rows that do not contain an underscore. Can you offer any suggestions?
The underscore character is a single character wildcard in the same way the percent sign is a multi-character wildcard. To query for an underscore character you need to wrap the underscore in square brackets:
WHERE email LIKE 'gm[_]%'
If you want to search for all email addresses with a two character value then an underscore, this WHERE clause would work:
WHERE email like '__[_]%@%'
Related Q&A from Denny Cherry
Planning an upgrade to SQL Server 2008? Our expert weighs in on advantages and hardware requirements you should consider before upgrading to SQL ...continue reading
Learn how to troubleshoot SQL Server 2005 temporary table performance problems when a stored procedure execution time is slower than usual.continue reading
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.