sql server full text search: Search for Substring -- sql server full text search

Re: Search for Substring

Hilary Cotter
5/23/2005 12:00:00 AM

sql server full text search: not really, the recommended way of handling things like this is to store
your content in the database in reverse, so the string reverse would be
stored as esrever.

Then you would query like this select * from tablename where
contains(*,'9841*')

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Search for Substring

Binder
5/23/2005 1:22:30 PM

I want to search for a substring that is contained in one of the indexed
words.
For example, the catalog contains "00001498ABC"
I want to search for the substring "1489" since I don't know what the
leading characters are going to be, in this case four leading zeros.
I know the asterisk can be used as a wildcard when applied as a suffix.
Is there a method to find all words containing the substring?

Thanks