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-02-12 : 11:54:20
|
Kevin writes "Hi,
I have an application that allows users to search on a 4 digit error code field of a table. I'd like to be able to enter an error code into the database with reverse wildcard functionality so that many different searches will return the same record. I believe that my explaination so far is sorely vague so I'll illustrate an example:
Database table contains the record:
Code Description
---- ------------------------------------
xx23 This is the error for all xx23 searches
I want to be able to search for '0023','0123','4523' etc... and have the 'xx23' record returned. As far as I know, this functionality requires a kind of reverse wildcard search which I am not aware of. Is there a way I can do this in Sql2000 running W2K Server?
-Kevin"
|
|
|
|
|
|
How to perform reverse wildcard searches