SQL SERVER PATINDEX FORMULA

SQL SERVER PATINDEX FORMULA

-- THEORY

-- SELECT PATINDEX('ENTER TEXT TO SEARCH%', [COLUMN NAME TO SEARCH]) AS [ALIAS NAME], *

-- FROM [DATABASE NAME].[DATABASE OBJECT].[TABLE NAME] AS [ALIAS NAME]

-- Where PATINDEX('ENTER TEXT TO SEARCH%', [COLUMN NAME TO SEARCH]) = 1;

-- NOTE: 1 EQUALS TRUE AND 0 EQUALS FALSE OR (NOT TRUE)

-- EXAMPLE

SELECT PATINDEX('Bike%', PC.EnglishProductCategoryName) as [DISPLAY TRUE OR 1 FOR PATTERN INDEX MATCH ROW], *
FROM AdventureWorksDW2012.dbo.DimProductCategory as PC
where PATINDEX('Bike%', PC.EnglishProductCategoryName) = 1;