Use Of PatIndex in SQL Server

The SQL Server PATINDEX functions returns the location of a pattern in a string. The search is not case-sensitive.

Syntax:
PATINDEX( '%pattern%', string )

You can get more info in
http://www.techonthenet.com/sql_server/functions/patindex.php

https://msdn.microsoft.com/en-IN/library/ms188395.aspx

Mark as Answer if its helpful to you
---
Srihari

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

PATINDEX functions returns the location of a pattern in a string. The search is not case-sensitive.

syntax:
PATINDEX( '%pattern% ', string )

The pattern that you want to find. pattern must be surrounded by % characters. Other wildcard characters can be used in pattern, such as:

% -- Allows you to match any string of any length (including zero length)
_ -- Allows you to match on a single character
[ ] -- Allows you to match on any character in the [ ] brackets (for example, [aeiou] would match on a, e, i, o, or u characters)
[^] -- Allows you to match on any character not in the [^] brackets (for example, [^aeiou] would match on any character that is not a, e, i, o, or u characters)

refer this link for some example
http://sqlandme.com/2011/07/05/sql-functions-patindex/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

PATINDEX is used to get starting position of the first occurrence of a pattern in a specified expression.
Syntax of PATINDEX Function :
PATINDEX ( '%pattern%' ,expression )

Example:
Use of PATINDEX function in select clause

SELECT PATINDEX('%-E%','Syntax-Example') ;
Output
7
Above example returns position of starting index for characters '-E' in specified string.


Refer below link some examples
http://www.dailyfreecode.com/code/patindex-function-291.aspx

rajesh.plsql123@gmail.com

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Thanks Bandi.. :)

Feel free to share informations.
mail Id ' adityagupta200@gmail.com
Thanks

Amatya, if this helps please login to Mark As Answer. | Alert Moderator