T-SQL 101: #22 Using the LIKE operator in T-SQL

added by DotNetKicks
7/23/2019 12:32:25 PM

1 Kicks, 323 Views

I've discussed standard operators in previous posts but an interesting additional one is the LIKE operator. This allows for basic pattern matching in T-SQL predicates. Let's look at a simple example: WHERE ProductName LIKE 'Grant%' The % symbol is a wild-card that matches any set of characters, including no characters at all.