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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-12-09 : 05:28:33
|
| Hi there,I've recently had a problem with using the wild card '%'. Anytime I use it now, there is no results returned. I've used the where clause and used a field content that does exist then I delete some of it and add the wild card at the end and I receive no results.Does anyone know why this might be happening? perhaps there's a setting that has been re-configured?Thanks for any help! |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2009-12-09 : 05:32:05
|
| Do you have an example of the syntax you use which returns no results?Ryan Randall - Yak of all tradesSolutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2009-12-09 : 05:52:21
|
| I think the cold I have has seriously affeced my brain! I've used the equal sign rather than 'like'problem solved and sorry for wasting anyone's time with this!:s |
|
|
|
|
|
|
WildCard not working %