var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: NOOPS in SQL query
I need to exclude some words while doing a string comparison to get a good result. I do not need words like The, Of, And, In while comparing two strings. In short the record
The ABC Company OF XYZ
should match with BOTH
2. Company XYZ
Re: NOOPS in SQL query
Could you give us a bit more info of what you wanted to do? Or post your query if you can?
You could use function replace() for deleting all 'noise' words. List of 'noise' words you can find \Mssql\Ftdata\Sqlserver\Config if Full-Text Search is installed.
You can use the full text search feature of MS Sql server to do this kind of search operations.
Have you looked into using the 'CONTAINS' clause?
You can do something like:
WHERE CONTAINS(CompanyName, ' "ABC" OR "company" NEAR "XYZ" ')
(You have to have FullText Indexing turned on for this to work)