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 - 2001-11-09 : 14:34:58
|
| Eric writes "What should I use to search for a dash in a string?(e.g. I'm searching a SKU field. Some SKUs have a dash in it.e.g. cdc-506. Now the only way that would come up is eithersearching by 506, cdc, or cdc-506 etc.I even tried using the Soundex() and DIFFERENCE() functionsbut they just returned to irrelevant information.)Any advice?Thanks, Eric." |
|
|
|
|
|
Non text character search results (e.g. dashes - etc.)