Search for Substring

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Binder - 23 May 2005 18:22 GMT

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

Reply to this Message

Hilary Cotter - 23 May 2005 20:43 GMT

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*')

Signature

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

> I want to search for a substring that is contained in one of the indexed
> words.
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message