Full Text Query in Microsoft SQL Server
Full Text Query search used to search for the entire text instead of using “%”. We use it to search for text with data type TEXT or NOTE etc .
Some predicates like FREETEXT, CONTAINS are used in full text query search. FREETEXT finds the word or words you give it anywhere in the search column. For example
SELECT Apparel FROM Products WHERE FREETEXT (Apparel, 'Van' )
The output of above query will be : Best Van Huesen trousers
No comments:
Post a Comment