kenneth.mofokeng (9/26/2013)
Try something like this
SELECT *FROM dbo.KNB_ItemCultures
WHERE CONTAINS(MyColumnName, '"*How*" OR "*to*" OR "*migrate*" OR "*reports*" OR "*between*" OR "*different*" OR "*versions*"');
I don't want the records with any of the words... I want the records with all the words. This returns over 10.000 records and only less than 10 should be returned, with the exact text only one is returned.
Pedro