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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  CONTAINS and Wildcards

Author  Topic  Ferox Starting Member 18 Posts Posted - 2005-05-20 : 05:31:28 Is there a sound way I can search for a word that starts with a value and ends with a different value? What I mean is I'm using full-text searching so mostly I use CONTAINS to find records where words appear. But the user needs to include a wildcard like so: 'ESTAB*MENT' but I can't get the CONTAINS to search this way (although MS say this can be done with CONTAINS(myfield, '"ESTAB*MENT"')) Can any one help?