IndexOf-PATINDEX in SQL Server

Similar to the CharIndex and IndexOf functions in C # in SQL Server

CharIndex is the position of a Char, while PATINDEX can get the position of a string.

For example:

Code
DECLARE @ s VARCHAR (100)
SET @ s = 'fileguid = ed47252c-2d34-42d7-9faf-e5c32de82a5f'
Select patindex ('% FileGuid = %', @ s)

The result is 1.

If yes

Code
Select patindex ('% ed47252c % ')

The output result is 10.