Hey SQL smart peeps

[Sooner in Tampa]

How do I do a multiple digit wildcard search with SQL 2000??? Is it even possible? I am pretty sure that it HAS to be on the end...I can't do e**l and return evil...right??

i.e. SEARCH: Soone** would return Sooners.

TIA smart people

[dolemitesooner]

Check in the services list for "Microsoft Search." If not listed, insert the SQL Server media, and select "Upgrade, Add or Remove Components." Click next for "Add Components." On the next screen, select "Multiple," Full-Text Search, and then continue with the rest of Search.

The wild Card search is easy to multipile

[Ash]

Searches like that work in the database I'm using. For example, using the WHERE and LIKE with L* for Left, returns all "Left" entries. Same goes for L**t.

[SoonerInKCMO]

Does - where like 'L%t' - not work for finding Left, Loot, Lot, etc.?

[Norm In Norman]

Try '?'. for instance, 's??ners' would find 'sooners' but not 'swhattheheckisallthistextdoinginhereners' like 's*ners' would. i dunno if this works in SQL 2000 though. It works in Access, which is also a microsoft product.

[Pricetag]

Try the underscore character (_). It matches any single character.

[Ash]

Hey, all you hata's out there. Search this:
**** off, dip ****!

[Ash]

Try '?'. for instance, 's??ners' would find 'sooners' but not 'swhattheheckisallthistextdoinginhereners' like 's*ners' would. i dunno if this works in SQL 2000 though. It works in Access, which is also a microsoft product.



:D

[Sooner in Tampa]

The ? does nothing.

As far as using LIKE...we are trying to avoid that due to the large number of records in the database. We are using webservices to run these searches and want to really hum along.

[HoserSooner]

The only wildcard that I am aware of in SQL (Microsoft version as least) is the % sign. I use it on a daily basis around here, but I can't say how efficient it is.