{"id":17431,"date":"2024-01-18T09:55:47","date_gmt":"2024-01-18T08:55:47","guid":{"rendered":"https:\/\/www.dbvis.com\/?p=17431"},"modified":"2025-02-17T09:41:58","modified_gmt":"2025-02-17T08:41:58","slug":"sql-contains-function-sql-server-guide-with-examples","status":"publish","type":"post","link":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/","title":{"rendered":"SQL CONTAINS Function: SQL Server Guide With Examples"},"content":{"rendered":"\n<div class=\"wp-block-group has-black-background-color has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:40px;padding-bottom:20px\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-05153d0\" data-block-id=\"05153d0\"><style>.stk-05153d0 {max-width:672px !important;min-width:auto !important;margin-right:auto !important;margin-left:auto !important;}<\/style><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-05153d0-column alignwide\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-0ae88f8\" data-v=\"4\" data-block-id=\"0ae88f8\"><style>.stk-0ae88f8-container{max-width:600px !important;min-width:auto !important;margin-right:auto !important;margin-left:auto !important;}<\/style><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-0ae88f8-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-0ae88f8-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-68a9012 stk-subtitle\" data-block-id=\"68a9012\"><style>.stk-68a9012 .stk-block-text__text{font-size:14px !important;color:#7B7B7B !important;font-family:\"jetbrainsmono\", Sans-serif !important;}@media screen and (max-width:1199px){.stk-68a9012 .stk-block-text__text{font-size:14px !important;}}<\/style><p class=\"stk-block-text__text has-text-color\">intro<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-a8f1ca9\" data-block-id=\"a8f1ca9\"><style>.stk-a8f1ca9 .stk-block-text__text{font-size:16px !important;color:#ffffff !important;font-family:\"authenticsans\", Sans-serif !important;}@media screen and (max-width:1199px){.stk-a8f1ca9 .stk-block-text__text{font-size:16px !important;}}<\/style><p class=\"stk-block-text__text has-text-color has-white-color\">Explore the power of SQL <code>CONTAINS<\/code> function and understand how this function works with real-world examples.<\/p><\/div>\n\n\n<section class=\"thetableTools thetableTools__wrapper\">\n    <div class=\"thetableTools thetableTools__container\">\n        <span class=\"thetableTools thetableTools__subhead\">Tools used in the tutorial<\/span>\n        <div class=\"thetableTools thetableTools__table\">\n            <div class=\"thetableTools thetableTools__divider\"><\/div>\n            <div class=\"thetableTools thetableTools__headers\">\n                <span class=\"thetableTools thetableTools__header thetableTools__header--name\">Tool<\/span>\n                <span class=\"thetableTools thetableTools__header thetableTools__header--description\">Description<\/span>\n                <span class=\"thetableTools thetableTools__header thetableTools__header--link\">Link<\/span>\n            <\/div>\n                                <div class=\"thetableTools thetableTools__divider\"><\/div>\n                    <div class=\"thetableTools thetableTools__tool\">\n                        <div class=\"thetableTools thetableTools__col thetableTools__col--name\">\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--icon\"><img decoding=\"async\" width=\"40\" height=\"40\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/dbvis_logo_nopadding-42x42.png\" class=\"attachment-40x40 size-40x40\" alt=\"Dbvisualizer\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/dbvis_logo_nopadding-42x42.png 42w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/dbvis_logo_nopadding.png 50w\" sizes=\"(max-width: 40px) 100vw, 40px\" \/><\/span>\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--name\">DBVISUALIZER<\/span>\n                        <\/div>\n                        <div class=\"thetableTools thetableTools__col thetableTools__col--description\">\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--description\">TOP RATED DATABASE MANAGEMENT TOOL AND SQL CLIENT<\/span>\n                        <\/div>\n                        <div class=\"thetableTools thetableTools__col thetableTools__col--link\">\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--link\">\n                                <a href=\"\/download\/\" class=\"ctaBlock ctaBlock__ctaLink ctaBlock__ctaLink--internal\">DOWNLOAD<\/a>\n                            <\/span>\n                        <\/div>\n                    <\/div>                        <div class=\"thetableTools thetableTools__divider\"><\/div>\n        <\/div>\n    <\/div>\n<\/section>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c722\" data-block-id=\"67b2f5d58c722\"><style>.stk-67b2f5d58c722 {margin-top:40px !important;margin-bottom:0px !important;}.stk-67b2f5d58c722-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c722-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c723\" data-v=\"4\" data-block-id=\"67b2f5d58c723\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c723-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c723-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeee58a\" data-block-id=\"stk67b2f5aeee58a\"><p class=\"stk-block-text__text\">Full-text string searching is essential for finding data in the database based on advanced query criteria. This process is complex, which is why SQL Server offers specialized functions to simplify it. The SQL <code>CONTAINS<\/code> function servers exactly that role, offering a powerful tool designed for full-text search queries.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeee5bc\" data-block-id=\"stk67b2f5aeee5bc\"><p class=\"stk-block-text__text\">In this article, you will dig into the world of the <code>CONTAINS<\/code> SQL Server function. Uncover its syntax, mechanics, and practical applications through several examples.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeee5c2\" data-block-id=\"stk67b2f5aeee5c2\"><p class=\"stk-block-text__text\">Embark on a journey to understand the capabilities of <code>CONTAINS<\/code> in SQL Server!<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5aeee820\" id=\"stk67b2f5aeee820\" data-block-id=\"stk67b2f5aeee820\"><h2 class=\"stk-block-heading__text\">What Is the SQL CONTAINS Function in SQL Server?<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeee826\" data-block-id=\"stk67b2f5aeee826\"><p class=\"stk-block-text__text\"><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/queries\/contains-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\"><code>CONTAINS<\/code><\/a> is an SQL Server function to search for a word or phrase in one or more text columns using precise or fuzzy matching. Specifically,<code>CONTAINS<\/code> in SQL Server is a predicate to use in the <code>WHERE<\/code> clause to perform full-text search. <\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeee835\" data-block-id=\"stk67b2f5aeee835\"><p class=\"stk-block-text__text\">The column or columns to search in must be of character-based data types. <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-fulltext-index-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\">Also, they must be full-text indexed columns<\/a>.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeee83a\" data-block-id=\"stk67b2f5aeee83a\"><p class=\"stk-block-text__text\">In detail, the <code>CONTAINS<\/code> SQL Server function can search for:<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-stk67b2f5aeeea93\" data-block-id=\"stk67b2f5aeeea93\"><style>.stk-stk67b2f5aeeea93 .stk-block-icon-list-item__content{gap:8px !important;align-items:baseline !important;}.stk-stk67b2f5aeeea93 {--stk-icon-list-row-gap:8px !important;--stk-icon-height:8px !important;}<\/style><svg style=\"display:none\"><defs><g id=\"stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><svg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 100 100'><circle cx='50' cy='50' r='40'><\/circle><\/svg><\/g><\/defs><\/svg><div class=\"stk-block-icon-list__ul stk-block-icon-list--column\"><ul class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-a7445a4\" data-block-id=\"a7445a4\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">A specific word.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-1468e26\" data-block-id=\"1468e26\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">A particular phrase.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-1c8791f\" data-block-id=\"1c8791f\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">The prefix of a word.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-f99a08a\" data-block-id=\"f99a08a\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">The prefix of a phrase.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-35812d7\" data-block-id=\"35812d7\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">A word within a certain distance of another.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-adaf493\" data-block-id=\"adaf493\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">A word inflectionally generated from another (e.g., the word \u201cquery\u201d is the inflectional stem of \u201cqueries,\u201d \u201cqueried,\u201d and \u201dquerying\u201d).<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-0ba5075\" data-block-id=\"0ba5075\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeea93\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">A word that is a synonym of another word based on the specified thesaurus (e.g., the word \"discover\" can have synonyms such as \"find,\" \"uncover,\" and \"reveal\").<\/span><\/div><\/li>\n<\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5aeeeab8\" id=\"stk67b2f5aeeeab8\" data-block-id=\"stk67b2f5aeeeab8\"><h2 class=\"stk-block-heading__text\">How to Use CONTAINS in SQL Server<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeeeabb\" data-block-id=\"stk67b2f5aeeeabb\"><p class=\"stk-block-text__text\">Below is the T-SQL <code>CONTAINS<\/code> syntax in a sample query:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c72c\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> *<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> TableName<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span> (ColumnName | ( ColumnList ) | *, <span class=\"text-brand-green\">'SearchCondition'<\/span>)<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c72e\" data-block-id=\"67b2f5d58c72e\"><style>.stk-67b2f5d58c72e {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c72e-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c72e-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c72f\" data-v=\"4\" data-block-id=\"67b2f5d58c72f\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c72f-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c72f-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeeed68\" data-block-id=\"stk67b2f5aeeed68\"><p class=\"stk-block-text__text\">The arguments supported by the function are:<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-stk67b2f5aeeed6c\" data-block-id=\"stk67b2f5aeeed6c\"><style>.stk-stk67b2f5aeeed6c .stk-block-icon-list-item__content{gap:8px !important;align-items:baseline !important;}.stk-stk67b2f5aeeed6c {--stk-icon-list-row-gap:8px !important;--stk-icon-height:8px !important;}<\/style><svg style=\"display:none\"><defs><g id=\"stk-icon-list__icon-svg-def-stk67b2f5aeeed6c\"><svg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 100 100'><circle cx='50' cy='50' r='40'><\/circle><\/svg><\/g><\/defs><\/svg><div class=\"stk-block-icon-list__ul stk-block-icon-list--column\"><ul class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-af0d54d\" data-block-id=\"af0d54d\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeed6c\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>ColumnName<\/code>: The name of the full-text indexed column in the <code>&lt;TableName&gt;<\/code> table to apply <code>SearchCondition<\/code> to.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-dee7074\" data-block-id=\"dee7074\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeed6c\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>ColumnList<\/code>: The list of columns, separated by commas, and enclosed in parentheses to apply <code>SearchCondition<\/code> to.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-18c0739\" data-block-id=\"18c0739\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeed6c\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>*<\/code>: Specifies that the SQL <code>CONTAINS<\/code> string search query will involve all full-text indexed columns in the <code>&lt;TableName&gt;<\/code> table.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-e2d5986\" data-block-id=\"e2d5986\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5aeeed6c\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>&lt;SearchCondition&gt;<\/code>: A <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/data-types\/nchar-and-nvarchar-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\"><code>nvarchar<\/code><\/a> string that contains the text to search for and the conditions for a match. This can also include SQL Server full-text search operators such as <code>OR<\/code>, <code>AND<\/code>, and <code>AND NOT<\/code>. Check out the docs to find out all the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/search\/query-with-full-text-search?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\">full-text search capabilities offered by Transact-SQL<\/a>.<\/span><\/div><\/li>\n<\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeeed8e\" data-block-id=\"stk67b2f5aeeed8e\"><p class=\"stk-block-text__text\"><strong>Note<\/strong>: The first three arguments are connected by a logical OR, so the SQL <code>CONTAINS<\/code> function can accept as the first argument either a column name, a comma-separated list of columns, or <code>*<\/code>.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5aeeed99\" id=\"stk67b2f5aeeed99\" data-block-id=\"stk67b2f5aeeed99\"><h3 class=\"stk-block-heading__text\">Your First SQL CONTAINS Example<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeeed9b\" data-block-id=\"stk67b2f5aeeed9b\"><p class=\"stk-block-text__text\">Consider the <code>CONTAINS<\/code> SQL Server example query below:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c733\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>((Name, Description), <span class=\"text-brand-green\">'Laptop'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c734\" data-block-id=\"67b2f5d58c734\"><style>.stk-67b2f5d58c734 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c734-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c734-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c735\" data-v=\"4\" data-block-id=\"67b2f5d58c735\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c735-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c735-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5aeeeda3\" data-block-id=\"stk67b2f5aeeeda3\"><p class=\"stk-block-text__text\">That will return the products whose <code>Name<\/code> and <code>Description<\/code> columns contain the word \u201cLaptop.\u201d Based on your table\u2019s collation, <code>CONTAINS<\/code> will be case-sensitive or case-insensitive. As you can see from the results below, the result set involves the target keyword regardless of its case:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c737\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-1024x608.png\" class=\"attachment-large size-large\" alt=\"Executing the SQL CONTAINS query in DbVisualizer\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image-35-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Executing the SQL CONTAINS query in DbVisualizer<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c73a\" data-block-id=\"67b2f5d58c73a\"><style>.stk-67b2f5d58c73a {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c73a-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c73a-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c73b\" data-v=\"4\" data-block-id=\"67b2f5d58c73b\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c73b-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c73b-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353e54\" data-block-id=\"stk67b2f5b353e54\"><p class=\"stk-block-text__text\">If <code>Name<\/code> and <code>Description<\/code> columns were not full-text indexed, the query would fail with:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c73c\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">Cannot use a <span class=\"text-product-orange\">CONTAINS<\/span> or FREETEXT predicate on table or indexed view <span class=\"text-brand-green\">'&lt;YourTable&gt;'<\/span> because it is not full-text indexed.<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c73d\" data-block-id=\"67b2f5d58c73d\"><style>.stk-67b2f5d58c73d {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c73d-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c73d-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c73e\" data-v=\"4\" data-block-id=\"67b2f5d58c73e\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c73e-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c73e-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353e9a\" data-block-id=\"stk67b2f5b353e9a\"><p class=\"stk-block-text__text\">To avoid that, you need to define a <code>FULLTEXT<\/code> index involving the columns to apply <code>CONTAINS<\/code> to. <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-fulltext-index-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\">Take a look at the SQL Server documentation to learn how<\/a>. In detail, you would have to launch a query as below:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c73f\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE<\/span> FULLTEXT CATALOG ProductCatalog <span class=\"text-product-orange\">AS<\/span> <span class=\"text-product-orange\">DEFAULT<\/span>;<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE<\/span> FULLTEXT <span class=\"text-product-orange\">INDEX<\/span> <span class=\"text-product-orange\">ON<\/span> Product(Name, Description)<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">4<\/span>\n                    <span class=\"codeBlock codeBlock__line\">KEY <span class=\"text-product-orange\">INDEX<\/span> PK__Product__3214EC07303CD7E1;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c741\" data-block-id=\"67b2f5d58c741\"><style>.stk-67b2f5d58c741 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c741-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c741-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c742\" data-v=\"4\" data-block-id=\"67b2f5d58c742\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c742-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c742-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353eb0\" data-block-id=\"stk67b2f5b353eb0\"><p class=\"stk-block-text__text\">Unfortunately, the full-text search component is optional in SQL Server. Thus, your <code>FULLTEXT<\/code> index creation query may fail with:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c743\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">[Code: 7609, SQL State: S1000] Full-Text Search is not installed, or a full-text component cannot be loaded.<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c745\" data-block-id=\"67b2f5d58c745\"><style>.stk-67b2f5d58c745 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c745-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c745-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c746\" data-v=\"4\" data-block-id=\"67b2f5d58c746\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c746-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c746-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353eb9\" data-block-id=\"stk67b2f5b353eb9\"><p class=\"stk-block-text__text\">Learn how to install it in the next section. If this is not your case, feel free to skip to the next main chapter.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5b353ec8\" id=\"stk67b2f5b353ec8\" data-block-id=\"stk67b2f5b353ec8\"><h3 class=\"stk-block-heading__text\">Add the Full-Text Search Component on SQL Server 2022<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353ecb\" data-block-id=\"stk67b2f5b353ecb\"><p class=\"stk-block-text__text\">Launch the query below to make sure that the Full-Text Search component is installed:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c749\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> SERVERPROPERTY(<span class=\"text-brand-green\">'IsFullTextInstalled'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c74a\" data-block-id=\"67b2f5d58c74a\"><style>.stk-67b2f5d58c74a {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c74a-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c74a-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c74b\" data-v=\"4\" data-block-id=\"67b2f5d58c74b\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c74b-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c74b-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353ed1\" data-block-id=\"stk67b2f5b353ed1\"><p class=\"stk-block-text__text\">If it returns <code>1<\/code>, it is already installed. However, if it returns <code>0<\/code>, you need to add it to your SQL Server.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b353ed9\" data-block-id=\"stk67b2f5b353ed9\"><p class=\"stk-block-text__text\">Download the installer of the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noopener\">Developer edition of SQL Server<\/a>. Double-click it, and select the \u201cCustom\u201d option. What for the installer to load and click on the \u201cInstallation\u201d menu entry on the right. Next, select \u201cNew SQL Server standalone installation or add features to an existing installation\u201d as in the image below:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c74d\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--light thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--light thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--light thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"785\" height=\"592\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/PrRF4FdPed-e5Yh8_w_JIPY7GrHn29DwKYc4bkdup-u8Rjq9aW6emjP6uGqfm6IlKTC91dgE2iaKJu-6wc9BoWH6Q7nJMy8A1iGzcYvy3_U8Wn-sLWiSc8fYOrWQzW1izMXnVgxexrlCiCjhfVpoPUc-6.png\" class=\"attachment-large size-large\" alt=\"Click on the first option\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/PrRF4FdPed-e5Yh8_w_JIPY7GrHn29DwKYc4bkdup-u8Rjq9aW6emjP6uGqfm6IlKTC91dgE2iaKJu-6wc9BoWH6Q7nJMy8A1iGzcYvy3_U8Wn-sLWiSc8fYOrWQzW1izMXnVgxexrlCiCjhfVpoPUc-6.png 785w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/PrRF4FdPed-e5Yh8_w_JIPY7GrHn29DwKYc4bkdup-u8Rjq9aW6emjP6uGqfm6IlKTC91dgE2iaKJu-6wc9BoWH6Q7nJMy8A1iGzcYvy3_U8Wn-sLWiSc8fYOrWQzW1izMXnVgxexrlCiCjhfVpoPUc-6-300x226.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/PrRF4FdPed-e5Yh8_w_JIPY7GrHn29DwKYc4bkdup-u8Rjq9aW6emjP6uGqfm6IlKTC91dgE2iaKJu-6wc9BoWH6Q7nJMy8A1iGzcYvy3_U8Wn-sLWiSc8fYOrWQzW1izMXnVgxexrlCiCjhfVpoPUc-6-768x579.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/PrRF4FdPed-e5Yh8_w_JIPY7GrHn29DwKYc4bkdup-u8Rjq9aW6emjP6uGqfm6IlKTC91dgE2iaKJu-6wc9BoWH6Q7nJMy8A1iGzcYvy3_U8Wn-sLWiSc8fYOrWQzW1izMXnVgxexrlCiCjhfVpoPUc-6-42x32.png 42w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--light thetableImage__imageCaption--narrow\">Click on the first option<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c74e\" data-block-id=\"67b2f5d58c74e\"><style>.stk-67b2f5d58c74e {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c74e-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c74e-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c74f\" data-v=\"4\" data-block-id=\"67b2f5d58c74f\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c74f-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c74f-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b3ecfdb\" data-block-id=\"stk67b2f5b3ecfdb\"><p class=\"stk-block-text__text\">Keep clicking the \u201cNext\u201d button until you reach the following screen:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c750\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--light thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--light thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--light thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"804\" height=\"707\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/DeBKcMCr51ZWKHzhVKE6fyUqe1uspy_4CyckDHMMuDWCEo-I39xOD7K0ZmqDTpg3n2azD_uqkTTtcVkuFrcTzODbkOKdfjsffR04UeNwyCJq21aplO0YHHM0eEKW3GUZkrZCHQII9zpTlTfr4G00axw-6.png\" class=\"attachment-large size-large\" alt=\"All operations have been completed and you can click Next\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/DeBKcMCr51ZWKHzhVKE6fyUqe1uspy_4CyckDHMMuDWCEo-I39xOD7K0ZmqDTpg3n2azD_uqkTTtcVkuFrcTzODbkOKdfjsffR04UeNwyCJq21aplO0YHHM0eEKW3GUZkrZCHQII9zpTlTfr4G00axw-6.png 804w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/DeBKcMCr51ZWKHzhVKE6fyUqe1uspy_4CyckDHMMuDWCEo-I39xOD7K0ZmqDTpg3n2azD_uqkTTtcVkuFrcTzODbkOKdfjsffR04UeNwyCJq21aplO0YHHM0eEKW3GUZkrZCHQII9zpTlTfr4G00axw-6-300x264.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/DeBKcMCr51ZWKHzhVKE6fyUqe1uspy_4CyckDHMMuDWCEo-I39xOD7K0ZmqDTpg3n2azD_uqkTTtcVkuFrcTzODbkOKdfjsffR04UeNwyCJq21aplO0YHHM0eEKW3GUZkrZCHQII9zpTlTfr4G00axw-6-768x675.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/DeBKcMCr51ZWKHzhVKE6fyUqe1uspy_4CyckDHMMuDWCEo-I39xOD7K0ZmqDTpg3n2azD_uqkTTtcVkuFrcTzODbkOKdfjsffR04UeNwyCJq21aplO0YHHM0eEKW3GUZkrZCHQII9zpTlTfr4G00axw-6-42x37.png 42w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--light thetableImage__imageCaption--narrow\">All operations have been completed and you can click \u201cNext\u201d<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c751\" data-block-id=\"67b2f5d58c751\"><style>.stk-67b2f5d58c751 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c751-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c751-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c752\" data-v=\"4\" data-block-id=\"67b2f5d58c752\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c752-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c752-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b484811\" data-block-id=\"stk67b2f5b484811\"><p class=\"stk-block-text__text\">Click \u201cNext\u201d again and select the second option as follows:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c753\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--light thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--light thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--light thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"804\" height=\"707\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/2ulWuuMTEEQrzB3enpYM6K2Z7gZF6p0i2AooW2yA7GKub41CRgQh6AX0_BH7Lgathjs30Y9hO4Uj9AyRK0hrdjoZ65fiQeQBD3ML_VylkBBlN1z85bzCldaj7Dg4GaPHLPQa2brcF4W9Sq4macVqxXQ-6.png\" class=\"attachment-large size-large\" alt=\"Click Next\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/2ulWuuMTEEQrzB3enpYM6K2Z7gZF6p0i2AooW2yA7GKub41CRgQh6AX0_BH7Lgathjs30Y9hO4Uj9AyRK0hrdjoZ65fiQeQBD3ML_VylkBBlN1z85bzCldaj7Dg4GaPHLPQa2brcF4W9Sq4macVqxXQ-6.png 804w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/2ulWuuMTEEQrzB3enpYM6K2Z7gZF6p0i2AooW2yA7GKub41CRgQh6AX0_BH7Lgathjs30Y9hO4Uj9AyRK0hrdjoZ65fiQeQBD3ML_VylkBBlN1z85bzCldaj7Dg4GaPHLPQa2brcF4W9Sq4macVqxXQ-6-300x264.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/2ulWuuMTEEQrzB3enpYM6K2Z7gZF6p0i2AooW2yA7GKub41CRgQh6AX0_BH7Lgathjs30Y9hO4Uj9AyRK0hrdjoZ65fiQeQBD3ML_VylkBBlN1z85bzCldaj7Dg4GaPHLPQa2brcF4W9Sq4macVqxXQ-6-768x675.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/2ulWuuMTEEQrzB3enpYM6K2Z7gZF6p0i2AooW2yA7GKub41CRgQh6AX0_BH7Lgathjs30Y9hO4Uj9AyRK0hrdjoZ65fiQeQBD3ML_VylkBBlN1z85bzCldaj7Dg4GaPHLPQa2brcF4W9Sq4macVqxXQ-6-42x37.png 42w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--light thetableImage__imageCaption--narrow\">Click \u201cNext\u201d<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c754\" data-block-id=\"67b2f5d58c754\"><style>.stk-67b2f5d58c754 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c754-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c754-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c755\" data-v=\"4\" data-block-id=\"67b2f5d58c755\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c755-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c755-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b519518\" data-block-id=\"stk67b2f5b519518\"><p class=\"stk-block-text__text\">Uncheck the \u201cAzure Extension for SQL Server\u201d option and press the \u201cNext\u201d button:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c756\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--light thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--light thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--light thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"804\" height=\"707\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/Ls8hPag9zTY3KhNus8-fwG1qij0d3ZmgXeGi9VfMFZc8tay9TpltR_irQv5RFr42fRCv8GR3s4O_RLI3WCh6xLQDluKZ-wK9ANDwajIs8T5vdIqQJmf97WOkI558MELQcfYnRWUtCkrZrOegYOAYm-g-6.png\" class=\"attachment-large size-large\" alt=\"Make sure to uncheck the first option\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/Ls8hPag9zTY3KhNus8-fwG1qij0d3ZmgXeGi9VfMFZc8tay9TpltR_irQv5RFr42fRCv8GR3s4O_RLI3WCh6xLQDluKZ-wK9ANDwajIs8T5vdIqQJmf97WOkI558MELQcfYnRWUtCkrZrOegYOAYm-g-6.png 804w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/Ls8hPag9zTY3KhNus8-fwG1qij0d3ZmgXeGi9VfMFZc8tay9TpltR_irQv5RFr42fRCv8GR3s4O_RLI3WCh6xLQDluKZ-wK9ANDwajIs8T5vdIqQJmf97WOkI558MELQcfYnRWUtCkrZrOegYOAYm-g-6-300x264.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/Ls8hPag9zTY3KhNus8-fwG1qij0d3ZmgXeGi9VfMFZc8tay9TpltR_irQv5RFr42fRCv8GR3s4O_RLI3WCh6xLQDluKZ-wK9ANDwajIs8T5vdIqQJmf97WOkI558MELQcfYnRWUtCkrZrOegYOAYm-g-6-768x675.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/Ls8hPag9zTY3KhNus8-fwG1qij0d3ZmgXeGi9VfMFZc8tay9TpltR_irQv5RFr42fRCv8GR3s4O_RLI3WCh6xLQDluKZ-wK9ANDwajIs8T5vdIqQJmf97WOkI558MELQcfYnRWUtCkrZrOegYOAYm-g-6-42x37.png 42w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--light thetableImage__imageCaption--narrow\">Make sure to uncheck the first option<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c757\" data-block-id=\"67b2f5d58c757\"><style>.stk-67b2f5d58c757 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c757-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c757-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c758\" data-v=\"4\" data-block-id=\"67b2f5d58c758\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c758-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c758-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b5a0df4\" data-block-id=\"stk67b2f5b5a0df4\"><p class=\"stk-block-text__text\">Check the \u201cFull-Text and Semantic Extractions for Search\u201d component, click \u201cNext,\u201d and wait for the installation process to end.<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c759\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--light thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--light thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--light thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"804\" height=\"707\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/EQESykN3IUpG62X-OJXZAjDQ4vFmZh0s5dCN6QtekhmMhLR2iFX7LmZWNbIByVgGOswsXPFN2VrruxSMk7cVuSVzswiSBoKvEq4vba9fTSJMG10LTbu8agB0WwHyFJM7o4aBJEvj3m39JoLgRFYelsA-6.png\" class=\"attachment-large size-large\" alt=\"Find the Full-Text SQL Server component and install it\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/EQESykN3IUpG62X-OJXZAjDQ4vFmZh0s5dCN6QtekhmMhLR2iFX7LmZWNbIByVgGOswsXPFN2VrruxSMk7cVuSVzswiSBoKvEq4vba9fTSJMG10LTbu8agB0WwHyFJM7o4aBJEvj3m39JoLgRFYelsA-6.png 804w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/EQESykN3IUpG62X-OJXZAjDQ4vFmZh0s5dCN6QtekhmMhLR2iFX7LmZWNbIByVgGOswsXPFN2VrruxSMk7cVuSVzswiSBoKvEq4vba9fTSJMG10LTbu8agB0WwHyFJM7o4aBJEvj3m39JoLgRFYelsA-6-300x264.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/EQESykN3IUpG62X-OJXZAjDQ4vFmZh0s5dCN6QtekhmMhLR2iFX7LmZWNbIByVgGOswsXPFN2VrruxSMk7cVuSVzswiSBoKvEq4vba9fTSJMG10LTbu8agB0WwHyFJM7o4aBJEvj3m39JoLgRFYelsA-6-768x675.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/EQESykN3IUpG62X-OJXZAjDQ4vFmZh0s5dCN6QtekhmMhLR2iFX7LmZWNbIByVgGOswsXPFN2VrruxSMk7cVuSVzswiSBoKvEq4vba9fTSJMG10LTbu8agB0WwHyFJM7o4aBJEvj3m39JoLgRFYelsA-6-42x37.png 42w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--light thetableImage__imageCaption--narrow\">Find the \u201cFull-Text\u201d SQL Server component and install it<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c75a\" data-block-id=\"67b2f5d58c75a\"><style>.stk-67b2f5d58c75a {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c75a-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c75a-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c75b\" data-v=\"4\" data-block-id=\"67b2f5d58c75b\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c75b-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c75b-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b64b148\" data-block-id=\"stk67b2f5b64b148\"><p class=\"stk-block-text__text\">Note that you can follow this procedure to install other essential additional modules such as \u201cSQL Server Replication.\u201d<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b64b159\" data-block-id=\"stk67b2f5b64b159\"><p class=\"stk-block-text__text\">Now, reconnect to your SQL Server and you are ready to use the SQL <code>CONTAINS<\/code> function!<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5b64b18f\" id=\"stk67b2f5b64b18f\" data-block-id=\"stk67b2f5b64b18f\"><h2 class=\"stk-block-heading__text\">CONTAINS SQL Server Use Cases<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b64b193\" data-block-id=\"stk67b2f5b64b193\"><p class=\"stk-block-text__text\">Learn how to use <code>CONTAINS<\/code> in SQL Server by exploring the most common possible scenarios through real-world examples.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b64b199\" data-block-id=\"stk67b2f5b64b199\"><p class=\"stk-block-text__text\"><strong>Note<\/strong>: The SQL <code>CONTAINS<\/code> queries below will be executed in <a href=\"https:\/\/www.dbvis.com\/\">DbVisualizer<\/a>, a fully-featured, powerful, multi-database client with the highest user satisfaction in the market <\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b64b1a7\" data-block-id=\"stk67b2f5b64b1a7\"><p class=\"stk-block-text__text\">In particular, the queries will be run on the following <code>Product<\/code> table:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c75e\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-1024x608.png\" class=\"attachment-large size-large\" alt=\"The data in the Product table as presented by DbVisualizer\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_1-18-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">The data in the Product table as presented by DbVisualizer<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c760\" data-block-id=\"67b2f5d58c760\"><style>.stk-67b2f5d58c760 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c760-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c760-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c761\" data-v=\"4\" data-block-id=\"67b2f5d58c761\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c761-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c761-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b9cde0f\" data-block-id=\"stk67b2f5b9cde0f\"><p class=\"stk-block-text__text\">As you can see, it stores information about some products.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5b9cde27\" id=\"stk67b2f5b9cde27\" data-block-id=\"stk67b2f5b9cde27\"><h3 class=\"stk-block-heading__text\">Search for a Single Term<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b9cde2a\" data-block-id=\"stk67b2f5b9cde2a\"><p class=\"stk-block-text__text\">The following example finds all products with a price of more than 40 units of value that contain the word \u201cwireless\u201d in their description:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c763\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> Price &gt; 40 <span class=\"text-product-orange\">AND<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(Description, <span class=\"text-brand-green\">'wireless'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c764\" data-block-id=\"67b2f5d58c764\"><style>.stk-67b2f5d58c764 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c764-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c764-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c765\" data-v=\"4\" data-block-id=\"67b2f5d58c765\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c765-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c765-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5b9cde3a\" data-block-id=\"stk67b2f5b9cde3a\"><p class=\"stk-block-text__text\">Execute the query, and you will get the following result:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c766\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-1024x608.png\" class=\"attachment-large size-large\" alt=\"Two products contain the word wireless in their description, but only one has a price higher than 40\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_2-13-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Two products contain the word \u201cwireless\u201d in their description, but only one has a price higher than 40<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c767\" data-block-id=\"67b2f5d58c767\"><style>.stk-67b2f5d58c767 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c767-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c767-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c768\" data-v=\"4\" data-block-id=\"67b2f5d58c768\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c768-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c768-inner-blocks\">\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5bd2432d\" id=\"stk67b2f5bd2432d\" data-block-id=\"stk67b2f5bd2432d\"><h3 class=\"stk-block-heading__text\">Search for a Phrase<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5bd24331\" data-block-id=\"stk67b2f5bd24331\"><p class=\"stk-block-text__text\">The SQL <code>CONTAINS<\/code> example below returns all products that contain the \u201cdesigned for\u201d phrase:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c769\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(Description, <span class=\"text-brand-green\">'<span class=\"text-brand-green\">\"designed for\"<\/span>'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c76a\" data-block-id=\"67b2f5d58c76a\"><style>.stk-67b2f5d58c76a {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c76a-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c76a-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c76b\" data-v=\"4\" data-block-id=\"67b2f5d58c76b\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c76b-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c76b-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5bd243f4\" data-block-id=\"stk67b2f5bd243f4\"><p class=\"stk-block-text__text\">The result of the above <code>CONTAINS<\/code> SQL Server query will be:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c76c\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-1024x608.png\" class=\"attachment-large size-large\" alt=\"Two products contain the desired phrase\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_3-7-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Two products contain the desired phrase<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c76d\" data-block-id=\"67b2f5d58c76d\"><style>.stk-67b2f5d58c76d {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c76d-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c76d-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c76e\" data-v=\"4\" data-block-id=\"67b2f5d58c76e\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c76e-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c76e-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c0b153d\" data-block-id=\"stk67b2f5c0b153d\"><p class=\"stk-block-text__text\">Note the use of the double quotes. Without them the query will fail with:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c76f\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">Syntax error near <span class=\"text-brand-green\">'for'<\/span> in the full-text search condition <span class=\"text-brand-green\">'designed for-'<\/span>.<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c770\" data-block-id=\"67b2f5d58c770\"><style>.stk-67b2f5d58c770 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c770-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c770-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c771\" data-v=\"4\" data-block-id=\"67b2f5d58c771\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c771-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c771-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c0b1559\" data-block-id=\"stk67b2f5c0b1559\"><p class=\"stk-block-text__text\">This is because double quotes are required on Transact-SQL full-text search conditions involving multiple words or special operators.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c0b155d\" data-block-id=\"stk67b2f5c0b155d\"><p class=\"stk-block-text__text\">Keep in mind that different database management systems may interpret special characters differently. For example, in MySQL:<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-stk67b2f5c0b1561\" data-block-id=\"stk67b2f5c0b1561\"><style>.stk-stk67b2f5c0b1561 .stk-block-icon-list-item__content{gap:8px !important;align-items:baseline !important;}.stk-stk67b2f5c0b1561 {--stk-icon-list-row-gap:8px !important;--stk-icon-height:8px !important;}<\/style><svg style=\"display:none\"><defs><g id=\"stk-icon-list__icon-svg-def-stk67b2f5c0b1561\"><svg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 100 100'><circle cx='50' cy='50' r='40'><\/circle><\/svg><\/g><\/defs><\/svg><div class=\"stk-block-icon-list__ul stk-block-icon-list--column\"><ul class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-e3d4634\" data-block-id=\"e3d4634\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5c0b1561\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>+<\/code> means \u201cmust contain.\u201d<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-e67b1f6\" data-block-id=\"e67b1f6\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5c0b1561\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>-<\/code> means \u201cmust not contain.\u201d<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-234ca94\" data-block-id=\"234ca94\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5c0b1561\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>*<\/code> denotes a wildcard.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-59f8a8d\" data-block-id=\"59f8a8d\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5c0b1561\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">Any text wrapped in double quotes (<code>\"\"<\/code>) means \u201cgive me an exact match.\u201d<\/span><\/div><\/li>\n<\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5c0b1634\" id=\"stk67b2f5c0b1634\" data-block-id=\"stk67b2f5c0b1634\"><h3 class=\"stk-block-heading__text\">Search for the Prefix of a Word<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c0b1638\" data-block-id=\"stk67b2f5c0b1638\"><p class=\"stk-block-text__text\">This query retrieves all products whose name contains at least one word starting with the \u201cW\u201d character:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c774\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(Description, <span class=\"text-brand-green\">'<span class=\"text-brand-green\">\"W*\"<\/span>'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c775\" data-block-id=\"67b2f5d58c775\"><style>.stk-67b2f5d58c775 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c775-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c775-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c776\" data-v=\"4\" data-block-id=\"67b2f5d58c776\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c776-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c776-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c0b1642\" data-block-id=\"stk67b2f5c0b1642\"><p class=\"stk-block-text__text\">The above query that show the usage of wildcards with <code>CONTAINS<\/code> in SQL Server will produce:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c777\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-1024x608.png\" class=\"attachment-large size-large\" alt=\"Note the wildcard * operator\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_4-5-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Note the wildcard * operator<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c778\" data-block-id=\"67b2f5d58c778\"><style>.stk-67b2f5d58c778 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c778-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c778-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c779\" data-v=\"4\" data-block-id=\"67b2f5d58c779\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c779-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c779-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c434968\" data-block-id=\"stk67b2f5c434968\"><p class=\"stk-block-text__text\">Notice the use of the double quotes and the <code>*<\/code> character to specify the prefix syntax in the <code>CONTAINS<\/code> SQL function. The double quotes are required; without them, the query won't fail but will return no results, as the <code>*<\/code> will be interpreted as a regular asterisk rather than a wildcard:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c77a\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-1024x608.png\" class=\"attachment-large size-large\" alt=\"See that this time you get no results\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_5-5-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">See that this time you get no results<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c77b\" data-block-id=\"67b2f5d58c77b\"><style>.stk-67b2f5d58c77b {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c77b-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c77b-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c77c\" data-v=\"4\" data-block-id=\"67b2f5d58c77c\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c77c-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c77c-inner-blocks\">\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5c792cf8\" id=\"stk67b2f5c792cf8\" data-block-id=\"stk67b2f5c792cf8\"><h3 class=\"stk-block-heading__text\">Word Proximity Search<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c792cff\" data-block-id=\"stk67b2f5c792cff\"><p class=\"stk-block-text__text\">The following SQL <code>CONTAINS<\/code> example query searches for all products whose description contains the word \u201ddevice\u201d within 5 search terms of the word \"smartphone\" in the specified order (\u201cdevice\u201d must precede \u201csmartphone\u201d):<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c77d\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(Description, <span class=\"text-brand-green\">'NEAR((device , smartphone), 5)'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c77e\" data-block-id=\"67b2f5d58c77e\"><style>.stk-67b2f5d58c77e {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c77e-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c77e-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c77f\" data-v=\"4\" data-block-id=\"67b2f5d58c77f\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c77f-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c77f-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5c792d3a\" data-block-id=\"stk67b2f5c792d3a\"><p class=\"stk-block-text__text\">The resulting dataset will be:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c780\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-1024x608.png\" class=\"attachment-large size-large\" alt=\"The description of the matching product contains the two words within the specified distance\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_6-4-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">The description of the matching product contains the two words within the specified distance<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c781\" data-block-id=\"67b2f5d58c781\"><style>.stk-67b2f5d58c781 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c781-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c781-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c782\" data-v=\"4\" data-block-id=\"67b2f5d58c782\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c782-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c782-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5cae775e\" data-block-id=\"stk67b2f5cae775e\"><p class=\"stk-block-text__text\">Find out more about the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/search\/search-for-words-close-to-another-word-with-near?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\"><code>NEAR<\/code><\/a> full-text operator.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5cae7840\" id=\"stk67b2f5cae7840\" data-block-id=\"stk67b2f5cae7840\"><h3 class=\"stk-block-heading__text\">Search for Inflectional Forms<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5cae7844\" data-block-id=\"stk67b2f5cae7844\"><p class=\"stk-block-text__text\">This query searches for all products with words of the form work (e.g. worked, working, and so on).<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c785\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(Description, <span class=\"text-brand-green\">'FORMSOF (INFLECTIONAL, work)'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c786\" data-block-id=\"67b2f5d58c786\"><style>.stk-67b2f5d58c786 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c786-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c786-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c787\" data-v=\"4\" data-block-id=\"67b2f5d58c787\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c787-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c787-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5cae7850\" data-block-id=\"stk67b2f5cae7850\"><p class=\"stk-block-text__text\">The result will be:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c788\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-1024x608.png\" class=\"attachment-large size-large\" alt=\"The resulting products containing the inflectional forms of the word work in their description\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_7-2-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">The resulting products containing the inflectional forms of the word \u201cwork\u201d in their description<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c789\" data-block-id=\"67b2f5d58c789\"><style>.stk-67b2f5d58c789 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c789-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c789-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c78a\" data-v=\"4\" data-block-id=\"67b2f5d58c78a\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c78a-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c78a-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5ce6fe19\" data-block-id=\"stk67b2f5ce6fe19\"><p class=\"stk-block-text__text\">Note that the product \u201cSmartwatch\u201d contains the word \u201cworking\u201d but not \u201cwork.\u201d That is still a match as \u201cworking\u201d is an inflectional form of \u201cwork.\u201d<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5ce6fe2c\" id=\"stk67b2f5ce6fe2c\" data-block-id=\"stk67b2f5ce6fe2c\"><h3 class=\"stk-block-heading__text\">Search Through Logical Operators<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5ce6fe2f\" data-block-id=\"stk67b2f5ce6fe2f\"><p class=\"stk-block-text__text\">The <code>CONTAINS<\/code> predicate in the query below will search for descriptions that contain both the word \u201ccomfortable\u201d and the word \u201clong:\u201d<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c78c\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(Description, <span class=\"text-brand-green\">'comfortable <span class=\"text-product-orange\">AND<\/span> long'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c78d\" data-block-id=\"67b2f5d58c78d\"><style>.stk-67b2f5d58c78d {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c78d-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c78d-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c78e\" data-v=\"4\" data-block-id=\"67b2f5d58c78e\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c78e-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c78e-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5ce6ff03\" data-block-id=\"stk67b2f5ce6ff03\"><p class=\"stk-block-text__text\">The result will be:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c78f\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-1024x608.png\" class=\"attachment-large size-large\" alt=\"Note that the resulting product contains the two words as desired\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_8-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Note that the resulting product contains the two words as desired<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c790\" data-block-id=\"67b2f5d58c790\"><style>.stk-67b2f5d58c790 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c790-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c790-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c791\" data-v=\"4\" data-block-id=\"67b2f5d58c791\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c791-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c791-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d1cbb1f\" data-block-id=\"stk67b2f5d1cbb1f\"><p class=\"stk-block-text__text\">Notice the use of the <code>AND<\/code> operator. Similarly, you can use <code>OR<\/code> and <code>AND NOT<\/code>. <\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d1cbb5d\" id=\"stk67b2f5d1cbb5d\" data-block-id=\"stk67b2f5d1cbb5d\"><h3 class=\"stk-block-heading__text\">Search for Opposite Match<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d1cbb61\" data-block-id=\"stk67b2f5d1cbb61\"><p class=\"stk-block-text__text\">You can use <code>CONTAINS<\/code> to get all records that do not match some criteria with:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c793\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> Id, Name, Description<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> Product<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">NOT<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>(*, <span class=\"text-brand-green\">'Laptop'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c794\" data-block-id=\"67b2f5d58c794\"><style>.stk-67b2f5d58c794 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c794-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c794-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c795\" data-v=\"4\" data-block-id=\"67b2f5d58c795\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c795-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c795-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d1cbb70\" data-block-id=\"stk67b2f5d1cbb70\"><p class=\"stk-block-text__text\">The above SQL NOT <code>CONTAINS<\/code> query would produce:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67b2f5d58c796\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-1024x608.png\" class=\"attachment-large size-large\" alt=\"image.png\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/image_9-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">image.png<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c797\" data-block-id=\"67b2f5d58c797\"><style>.stk-67b2f5d58c797 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c797-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c797-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c798\" data-v=\"4\" data-block-id=\"67b2f5d58c798\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c798-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c798-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58be1f\" data-block-id=\"stk67b2f5d58be1f\"><p class=\"stk-block-text__text\">Note that the \u201cLaptop\u201d device has been excluded by the results.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58be2e\" data-block-id=\"stk67b2f5d58be2e\"><p class=\"stk-block-text__text\">Et voil\u00e0! You are now a SQL <code>CONTAINS<\/code> master. For more use cases, take a look at the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/search\/search-for-words-close-to-another-word-with-near?view=sql-server-ver16#examples\" target=\"_blank\" rel=\"noopener\">\u201cExamples\u201d section<\/a> on the official documentation.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58be8f\" id=\"stk67b2f5d58be8f\" data-block-id=\"stk67b2f5d58be8f\"><h2 class=\"stk-block-heading__text\">Conclusion<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58be92\" data-block-id=\"stk67b2f5d58be92\"><p class=\"stk-block-text__text\">In this guide to using <code>CONTAINS<\/code> in SQL Server, you learned what this function is and how it works. This powerful full-text search function helps you search for strings in text columns. Thanks to the many real-world examples shown above, you know how to use it in different scenarios.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58be99\" data-block-id=\"stk67b2f5d58be99\"><p class=\"stk-block-text__text\">Full-text searching is tricky! To better understand how to use the SQL <code>CONTAINS<\/code> function, you need a tool to visualize the data in the database. This is precisely the purpose of a powerful database client such as DbVisualizer! In addition to presenting data visually, it supports several DBMS technologies, offers advanced query optimization capabilities, and can generate ERD-like schemas. <a href=\"https:\/\/www.dbvis.com\/download\/\">Try DbVisualizer for free today!<\/a><\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58bea5\" id=\"stk67b2f5d58bea5\" data-block-id=\"stk67b2f5d58bea5\"><h2 class=\"stk-block-heading__text\">Appendix: Conditions Required by CONTAINS in SQL Server<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-67b2f5d58c376\" data-block-id=\"67b2f5d58c376\"><style>.stk-67b2f5d58c376 .stk-block-icon-list-item__content{gap:4px !important;align-items:baseline !important;}.stk-67b2f5d58c376 {--stk-icon-height:16px !important;}<\/style><div class=\"stk-block-icon-list__ol stk-block-icon-list--column\"><ol class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-ccf96fb\" data-block-id=\"ccf96fb\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk-block-icon-list-item__marker\" aria-hidden=\"true\"><\/span><span class=\"stk-block-icon-list-item__text\">The SQL <code>CONTAINS<\/code> function works on columns of the following types: <code>char<\/code>, <code>varchar<\/code>, <code>nchar<\/code>, <code>nvarchar<\/code>, <code>text<\/code>, <code>ntext<\/code>, <code>image<\/code>, <code>xml<\/code>, <code>varbinary<\/code>, and <code>varbinary(max)<\/code>.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-537a23e\" data-block-id=\"537a23e\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk-block-icon-list-item__marker\" aria-hidden=\"true\"><\/span><span class=\"stk-block-icon-list-item__text\">The columns in the <code>CONTAINS<\/code> clause must come from a single table and be full-text indexed.<\/span><\/div><\/li>\n<\/ol><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c3a6\" id=\"stk67b2f5d58c3a6\" data-block-id=\"stk67b2f5d58c3a6\"><h2 class=\"stk-block-heading__text\">FAQ<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c3aa\" id=\"stk67b2f5d58c3aa\" data-block-id=\"stk67b2f5d58c3aa\"><h3 class=\"stk-block-heading__text\">What is the difference between LIKE vs CONTAINS in SQL Server?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c3ac\" data-block-id=\"stk67b2f5d58c3ac\"><p class=\"stk-block-text__text\">The <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/queries\/contains-transact-sql?view=sql-server-ver16#comparison-of-like-to-full-text-search\" target=\"_blank\" rel=\"noopener\"><code>LIKE<\/code> vs <code>CONTAINS<\/code><\/a> SQL Server comparison boils down to a few facts:<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-stk67b2f5d58c3b7\" data-block-id=\"stk67b2f5d58c3b7\"><style>.stk-stk67b2f5d58c3b7 .stk-block-icon-list-item__content{gap:8px !important;align-items:baseline !important;}.stk-stk67b2f5d58c3b7 {--stk-icon-list-row-gap:8px !important;--stk-icon-height:8px !important;}<\/style><svg style=\"display:none\"><defs><g id=\"stk-icon-list__icon-svg-def-stk67b2f5d58c3b7\"><svg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 100 100'><circle cx='50' cy='50' r='40'><\/circle><\/svg><\/g><\/defs><\/svg><div class=\"stk-block-icon-list__ul stk-block-icon-list--column\"><ul class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-fdbe3bc\" data-block-id=\"fdbe3bc\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5d58c3b7\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>LIKE<\/code> is a pattern-matching operator used for simple string matching, while <code>CONTAINS<\/code> is used for more advanced full-text searching.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-7d8b2af\" data-block-id=\"7d8b2af\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5d58c3b7\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>LIKE<\/code> performs partial matching with wildcards, whereas <code>CONTAINS<\/code> considers word forms, synonyms, and allows weighted searches.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-5992929\" data-block-id=\"5992929\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5d58c3b7\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>CONTAINS<\/code> requires a full-text index, while <code>LIKE<\/code> does not.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-0d66cd9\" data-block-id=\"0d66cd9\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67b2f5d58c3b7\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>LIKE<\/code> is typically case-insensitive, while <code>CONTAINS<\/code> behavior depends on column collation.<\/span><\/div><\/li>\n<\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c3ce\" data-block-id=\"stk67b2f5d58c3ce\"><p class=\"stk-block-text__text\">Below is a summary table comparing <code>LIKE<\/code> and <code>CONTAINS<\/code> in SQL Server:<\/p><\/div>\n\n\n\n<figure style=\"font-size:16px\" class=\"wp-block-table\" data-block-type=\"core\"><table class=\"has-fixed-layout\" style=\"border-style:none;border-width:0px\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\"><strong>Feature<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong><code>LIKE<\/code><\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong><code>CONTAINS<\/code><\/strong><\/th><\/tr><\/thead><tbody><tr><td><strong>Type of Matching<\/strong><\/td><td>Simple string matching<\/td><td>Advanced full-text search<\/td><\/tr><tr><td><strong>Pattern Matching<\/strong><\/td><td>Uses wildcards (e.g., <code>%<\/code>, <code>_<\/code>) for partial matching<\/td><td>Supports word forms, synonyms, and weighted searches<\/td><\/tr><tr><td><strong>Index Requirement<\/strong><\/td><td>No index required<\/td><td>Requires a full-text index<\/td><\/tr><tr><td><strong>Case Sensitivity<\/strong><\/td><td>Typically case-insensitive (depends on collation)<\/td><td>Depends on column collation (can be case-sensitive or case-insensitive)<\/td><\/tr><tr><td><strong>Performance<\/strong><\/td><td>Generally slower for large datasets<\/td><td>Optimized for large text-based datasets with full-text indexing<\/td><\/tr><tr><td><strong>Use Case<\/strong><\/td><td>Basic searches (e.g., <code>LIKE '%word%'<\/code>)<\/td><td>Complex searches involving words and their variations (e.g., <code>CONTAINS('word')<\/code>)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c638\" id=\"stk67b2f5d58c638\" data-block-id=\"stk67b2f5d58c638\"><h3 class=\"stk-block-heading__text\">Can I apply the SQL Server CONTAINS function on multiple columns?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c63a\" data-block-id=\"stk67b2f5d58c63a\"><p class=\"stk-block-text__text\">Yes, you can use the <code>CONTAINS<\/code> function on multiple columns by concatenating them with commas in the search condition as in the example below:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c79a\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> *<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> TableName<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> <span class=\"text-product-orange\">CONTAINS<\/span>((Column1, ..., ColumnN), <span class=\"text-brand-green\">'SearchCondition'<\/span>);<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c79b\" data-block-id=\"67b2f5d58c79b\"><style>.stk-67b2f5d58c79b {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c79b-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c79b-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c79c\" data-v=\"4\" data-block-id=\"67b2f5d58c79c\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c79c-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c79c-inner-blocks\">\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c650\" id=\"stk67b2f5d58c650\" data-block-id=\"stk67b2f5d58c650\"><h3 class=\"stk-block-heading__text\">How to check that a SQL string contains a substring?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c652\" data-block-id=\"stk67b2f5d58c652\"><p class=\"stk-block-text__text\">To check if a SQL string contains a substring, you can use the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/functions\/charindex-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noopener\">CHARINDEX<\/a> function as follows:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c79d\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">SELECT<\/span> *<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">FROM<\/span> TableName<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">WHERE<\/span> CHARINDEX(<span class=\"text-brand-green\">'substring'<\/span>, ColumnName) &gt; 0;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c79e\" data-block-id=\"67b2f5d58c79e\"><style>.stk-67b2f5d58c79e {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c79e-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c79e-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c79f\" data-v=\"4\" data-block-id=\"67b2f5d58c79f\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c79f-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c79f-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c65d\" data-block-id=\"stk67b2f5d58c65d\"><p class=\"stk-block-text__text\">This query returns rows where the specified substring is found within the specified column. Thus, you do not need <code>CONTAINS<\/code> to achieve the desired result.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c664\" id=\"stk67b2f5d58c664\" data-block-id=\"stk67b2f5d58c664\"><h3 class=\"stk-block-heading__text\">Does the CONTAINS SQL Server function work on columns that do not have a full-text index?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c666\" data-block-id=\"stk67b2f5d58c666\"><p class=\"stk-block-text__text\">No, the <code>CONTAINS<\/code> SQL Server function requires all columns mentioned in the predicate to have a full-text index. Otherwise, the query will fail with the following error:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67b2f5d58c7a0\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">Cannot use a <span class=\"text-product-orange\">CONTAINS<\/span> or FREETEXT predicate on table or indexed view <span class=\"text-brand-green\">'&lt;YourTable&gt;'<\/span> because it is not full-text indexed.<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67b2f5d58c7a1\" data-block-id=\"67b2f5d58c7a1\"><style>.stk-67b2f5d58c7a1 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67b2f5d58c7a1-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67b2f5d58c7a1-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67b2f5d58c7a2\" data-v=\"4\" data-block-id=\"67b2f5d58c7a2\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67b2f5d58c7a2-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67b2f5d58c7a2-inner-blocks\">\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c671\" id=\"stk67b2f5d58c671\" data-block-id=\"stk67b2f5d58c671\"><h3 class=\"stk-block-heading__text\">What is the full T-SQL CONTAINS syntax?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c672\" data-block-id=\"stk67b2f5d58c672\"><p class=\"stk-block-text__text\">You can find the full syntax of the&nbsp; SQL <code>CONTAINS<\/code> <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/queries\/contains-transact-sql?view=sql-server-ver16#syntax\" target=\"_blank\" rel=\"noopener\">on the documentation<\/a>. To view the Transact-SQL syntax of that function for SQL Server 2014 and earlier versions, explore the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/previous-versions-sql-server?view=sql-server-ver16#offline-documentation\" target=\"_blank\" rel=\"noopener\">documentation of the previous versions<\/a>.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67b2f5d58c680\" id=\"stk67b2f5d58c680\" data-block-id=\"stk67b2f5d58c680\"><h3 class=\"stk-block-heading__text\">What is the difference between using AND NOT in the CONTAINS operator and using the SQL NOT CONTAINS?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67b2f5d58c682\" data-block-id=\"stk67b2f5d58c682\"><p class=\"stk-block-text__text\">Using <code>AND NOT<\/code> with the <code>CONTAINS<\/code> operator means you are combining two conditions: one where the <code>CONTAINS<\/code> condition is true, and the other where a term or phrase is excluded. For example, <code>CONTAINS(Name, 'laptop') AND NOT CONTAINS(Description, 'tablet')<\/code>. On the other hand, the SQL <code>NOT CONTAINS<\/code> function excludes results based on a full-text search.<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" data-block-type=\"core\" data-block-type=\"core\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-1d92408 stk-block-background\" data-block-id=\"1d92408\"><style>.stk-1d92408 {background-color:var(--stk-global-color-70050, #f9f9e1) !important;margin-bottom:0px !important;}.stk-1d92408:before{background-color:var(--stk-global-color-70050, #f9f9e1) !important;}<\/style><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-1d92408-column alignwide\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-b8a8e51\" data-v=\"4\" data-block-id=\"b8a8e51\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-b8a8e51-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-b8a8e51-inner-blocks\">\n<div class=\"wp-block-stackable-image stk-block-image stk-block stk-d9669e0\" data-block-id=\"d9669e0\"><figure><a class=\"stk-link\" href=\"\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"stk-img-wrapper stk-image--shape-stretch\"><img decoding=\"async\" class=\"stk-img wp-image-26081\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-scaled.png\" width=\"2560\" height=\"577\" alt=\"Dbvis download link img\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-scaled.png 2560w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-300x68.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-1024x231.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-768x173.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-1536x346.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-2048x462.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-1300x293.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-42x9.png 42w\" sizes=\"(max-width: 2560px) 100vw, 2560px\" \/><\/span><\/a><\/figure><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>intro Explore the power of SQL CONTAINS function and understand how this function works with real-world examples. Full-text string searching is essential for finding data in the database based on advanced query criteria. This process is complex, which is why SQL Server offers specialized functions to simplify it. The SQL CONTAINS function servers exactly that [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[17],"class_list":["post-17431","post","type-post","status-publish","format-standard","hentry","category-thetable","tag-sql"],"acf":{"updated_date":"20250217","featured":false,"prio":"","highlighted":false,"type":"Guide","length":"10 min","author":[8009],"tools_used":[12272]},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Use CONTAINS in SQL Server: Guide With Examples<\/title>\n<meta name=\"description\" content=\"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use CONTAINS in SQL Server: Guide With Examples\" \/>\n<meta property=\"og:description\" content=\"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/\" \/>\n<meta property=\"og:site_name\" content=\"DbVisualizer\" \/>\n<meta property=\"article:author\" content=\"Antonello Zanini\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-18T08:55:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-17T08:41:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/og-329.png\" \/>\n<meta name=\"author\" content=\"Antonello Zanini\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to Use CONTAINS in SQL Server: Guide With Examples\" \/>\n<meta name=\"twitter:description\" content=\"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.\" \/>\n<meta name=\"twitter:creator\" content=\"@dbvisualizer\" \/>\n<meta name=\"twitter:site\" content=\"@dbvisualizer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antonello Zanini\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 min\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Use CONTAINS in SQL Server: Guide With Examples","description":"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/","og_locale":"en_US","og_type":"article","og_title":"How to Use CONTAINS in SQL Server: Guide With Examples","og_description":"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.","og_url":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/","og_site_name":"DbVisualizer","article_author":"Antonello Zanini","article_published_time":"2024-01-18T08:55:47+00:00","article_modified_time":"2025-02-17T08:41:58+00:00","og_image":[{"url":"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/og-329.png","type":"","width":"","height":""}],"author":"Antonello Zanini","twitter_card":"summary_large_image","twitter_title":"How to Use CONTAINS in SQL Server: Guide With Examples","twitter_description":"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.","twitter_creator":"@dbvisualizer","twitter_site":"@dbvisualizer","twitter_misc":{"Written by":"Antonello Zanini","Est. reading time":"10 min"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/#article","isPartOf":{"@id":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/"},"author":{"name":"Linda","@id":"https:\/\/www.dbvis.com\/#\/schema\/person\/220b74381f69bb6f0b2de51c19c6c5c3"},"headline":"SQL CONTAINS Function: SQL Server Guide With Examples","datePublished":"2024-01-18T08:55:47+00:00","dateModified":"2025-02-17T08:41:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/"},"wordCount":1739,"publisher":{"@id":"https:\/\/www.dbvis.com\/#organization"},"keywords":["SQL"],"articleSection":["TheTable"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/","url":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/","name":"How to Use CONTAINS in SQL Server: Guide With Examples","isPartOf":{"@id":"https:\/\/www.dbvis.com\/#website"},"datePublished":"2024-01-18T08:55:47+00:00","dateModified":"2025-02-17T08:41:58+00:00","description":"Explore the power of SQL CONTAINS function and understand how this function works with real-world examples.","breadcrumb":{"@id":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbvis.com\/thetable\/sql-contains-function-sql-server-guide-with-examples\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hem","item":"https:\/\/www.dbvis.com\/"},{"@type":"ListItem","position":2,"name":"SQL CONTAINS Function: SQL Server Guide With Examples"}]},{"@type":"WebSite","@id":"https:\/\/www.dbvis.com\/#website","url":"https:\/\/www.dbvis.com\/","name":"DbVisualizer","description":"","publisher":{"@id":"https:\/\/www.dbvis.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbvis.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbvis.com\/#organization","name":"DbVisualizer","alternateName":"DbVis","url":"https:\/\/www.dbvis.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbvis.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/08\/dbvisualizer_logo_squircle.svg","contentUrl":"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/08\/dbvisualizer_logo_squircle.svg","width":72,"height":72,"caption":"DbVisualizer"},"image":{"@id":"https:\/\/www.dbvis.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/dbvisualizer"]},{"@type":"Person","@id":"https:\/\/www.dbvis.com\/#\/schema\/person\/220b74381f69bb6f0b2de51c19c6c5c3","name":"Linda","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbvis.com\/wp-content\/litespeed\/avatar\/7e4cf781845f1f27037a5c6b10a6a5d7.jpg?ver=1776302580","url":"https:\/\/www.dbvis.com\/wp-content\/litespeed\/avatar\/7e4cf781845f1f27037a5c6b10a6a5d7.jpg?ver=1776302580","contentUrl":"https:\/\/www.dbvis.com\/wp-content\/litespeed\/avatar\/7e4cf781845f1f27037a5c6b10a6a5d7.jpg?ver=1776302580","caption":"Linda"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts\/17431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/comments?post=17431"}],"version-history":[{"count":9,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts\/17431\/revisions"}],"predecessor-version":[{"id":23445,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts\/17431\/revisions\/23445"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/thetable-tool\/12272"},{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/thetable-author\/8009"}],"wp:attachment":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/media?parent=17431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/categories?post=17431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/tags?post=17431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}