Microsoft SQL Sample Code

Using the PATINDEX Function

The SQL Server PATINDEX function Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types. The code below will show you how to use the PATINDEX function. For more details on the PATINDEX function click here

SELECT PATINDEX('%birth%', 'happy birthday to you')

If you need any help implementing this sql or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.