See requirement examples below.... any suggestions / ideas are helpful....
I am using SQL server 2005 and I have a limitation that I should not use full text search.
I have a table with nvarchar(100) column which holds data. Users will enter search terms on text box with predefined grammar. See examples below.....
1. BEFORE operator
"intersection before(n) car" finds intersection when it precedes car by n terms, where n is the nearness value
2. NEAR operator
"intersection near(n) car" finds intersection within n terms of car, where n is the nearness value
View Complete Post