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 |
|
Axxib
Starting Member
6 Posts |
 Posted - 2007-11-01 : 08:18:48
|
| HiI need to replace the use of wild cards in my query with something else which achieves the same thing. The problem is the web application which uses the query does throws an error when using '%' characters. Any ideas?The following statement appears in the where clause: AccType.Value like '@Opened_By[%DIST%APP% as Distance and Business Provider, DIST% as Distance, APP% as Business Provider]'Thanks |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-11-01 : 08:25:59
|
| try with the delimited identifiers....i mean []and ''VinodEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
|
|
|
Using Wildcards %