<div>
SQL uses CHARINDEX:<br />

<pre><code class="code-1 nolinks" id="code-20-40286441-1"><span>Select Distinct [CustomerID] From [CHILDREN] Where CHARINDEX('Jayden', [Child Name]) &gt; 0</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am trying to run the following query against a SQL database in my VB.net app but am getting an error that<br />
the Instr function is not recognized<br />
<br />
Select Distinct [CustomerID] From [CHILDREN] Where Instr([Child Name],'Jayden') &gt;&nbsp;0
</div>
</div>


Hi

I am trying to run the following query against a SQL database in my VB.net app but am getting an error that
the Instr function is not recognized

Select Distinct [CustomerID] From [CHILDREN] Where Instr([Child Name],'Jayden') > 0

VB.net SQL Instr Function

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

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.