Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-07 : 21:35:21
|
David writes "Is there any way to shorten the following statement?
SELECT MemberID from tblMain WHERE Field LIKE '%101%' OR Field LIKE '%102%' OR Field LIKE '%103%' OR Field LIKE '%104%'
This statement works fine, it just seems rather lengthly. By the way, the contents of Field looks like this:
101:30 days:1/1/2001, 102:3 months:3/1/2001, 105:none:1/1/1900
Thank you!" |
|
|
|
|
|
SQL LIKE statement