Thread: Wildcard characters in SQL

Hi. I am last year MCA student. I am learning SQL database language. I have to write very difficult query on the condition of "Matching Case". Someone told me that it will be very simple using "Wildcard characters”.. What are the different "Wildcard characters" in SQL? All possible replies and comments are appreciated.

Following are Wildcard characters in the SQL:

1. Percent symbol (%):
2. Asterisk (*): Used to match unlimited characters.
3. Question mark (?)
4. Underscore (_): Used to match only one character of the alphabet.