|
||||||
| BI Monkey BI Monkey is the ‘nom de plume’ of James Beresford, a Certified Microsoft BI Professional and MBA living and consulting in Sydney |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Senior Member
Join Date: Jun 2009
Posts: 62
![]() |
I recently came up against a scenario where, in amongst a number of other filters, I had to deal with a couple of wildcard criteria. As there is no option to have multiple LIKE clauses in native SQL, such as WHERE Field LIKE IN (’%Option1%’,'%Option2%’), I feared I was stuck with having to duplicate my WHERE clause in its entirety for each LIKE operation – until I found this cunning bit of code (from the thread here):
/* Apply Multiple LIKE clauses in a single WHERE clause */An*elegant solution! Get More from the original blog... |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Single Source Of Truth | admin | S - U | 0 | 26th January 2010 05:26 PM |
| Bottom up and top down approaches to estimating costs for a single BI report | Latest News Headlines | Forrester | 0 | 24th January 2010 10:56 AM |
| Be wary of ?the single metric? | Infohrm | Infohrm | 0 | 8th December 2009 04:32 PM |
| Industry fails to find a single mortgage trust structure | Latest News Headlines | Latest News | 0 | 25th November 2009 08:17 AM |
| GlobeOp Financial Services publishes Interim Management Statement | Latest News Headlines | Latest News | 0 | 27th October 2009 11:02 PM |
|
|
|
|
|
|