Difference between revisions of "CHARINDEX"

From SQL Server Wiki
Jump to: navigation, search
(Created page with "*https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-2017 <pre>CHARINDEX ( expressionToFind , expressionToSearch [ , start_location ]...")
 
 
Line 3: Line 3:
 
<pre>CHARINDEX ( expressionToFind , expressionToSearch [ , start_location ] )  </pre>
 
<pre>CHARINDEX ( expressionToFind , expressionToSearch [ , start_location ] )  </pre>
  
 +
<pre>select CHARINDEX('Test','Search this text as a test')
 +
 +
----
 +
23
 +
</pre>
 
===What Links Here===
 
===What Links Here===
 
{{Special:WhatLinksHere/{{PAGENAME}}}}
 
{{Special:WhatLinksHere/{{PAGENAME}}}}
  
 
[[category:tsql]]
 
[[category:tsql]]

Latest revision as of 15:29, 5 October 2018

CHARINDEX ( expressionToFind , expressionToSearch [ , start_location ] )  
select CHARINDEX('Test','Search this text as a test')

----
23

What Links Here[edit]