ramlicious Blogs by Tina & Prabhu

December 3, 2010

Using SQL Server’s thesaurus for an extended search

Filed under: SQL Server — Prabhuram @ 3:54 am

I was trying to differentiate Business and Individual customers in the Customer table. The easiest I found is to use the SQL thesaurus.

SELECT * FROM [Customer] WHERE CONTAINS (custname,'formsof(thesaurus, "ltd")')

Fulltext indexing should be enabled to perform this. This should return customers with names of all forms of limited.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.

Powered by WordPress