<div>
SELECT CHARINDEX('bicycle', [ProductDesc]) FROM Products<br />
If this returns a number greater than 1, then the string was found ... <br />
<br />
<br />

</div>


SELECT CHARINDEX('bicycle', [ProductDesc]) FROM Products
If this returns a number greater than 1, then the string was found ...




<div>
Little typo in the last comment ... if it returns a number greater than 0 ... the it was found
</div>


Little typo in the last comment ... if it returns a number greater than 0 ... the it was found

<div>
<div class="content wysiwyg-content">
In VB there is a &quot;.contain&quot; method to check to see if a string contains a char or a word we are looking for. Like if mystring.contains(&quot;,&quot;) then ... &nbsp; In T-Sql is there such a method? <br />

</div>
</div>


In VB there is a ".contain" method to check to see if a string contains a char or a word we are looking for. Like if mystring.contains(",") then ...   In T-Sql is there such a method? 


T-sql - contain?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.