In this article I will cover how to use wild cards in SQL Server. Wild cards are used when we want to filter data but not using exact match for instance a value should begin with specific characters or contain them or match certain pattern.
In this tutorial I will present you some samples witch wild cards.
In the sample below I used “%” wildcard to find any matching character.
In this case I want to find all missing data containing following text before ‘email@example.com’.
See screenshot below.
The sample below presents how to find Name containing Ball inside the percentage on both sides means that there can be missing text which will be finding by this wildcard.
Next wild card which I will present is “_” .
Underscore wildcard will much only one character.
The combination of “%” and “” gives us opportunity to fins all data ending on 1-9.
Next wildcards combination returns everything what starts from “a” to “c”.
I hope that will hepl