What are the different Wildcard characters in SQL?

[Leana_rus]

Hi All,

I have to write very complex query on the condition of "Matching Case". Somebody told me that it will be more easy using "Wildcard characters".But unfortunately I don't know anything about "Wildcard characters" available in the SQL. What are the different "Wildcard characters" in SQL? Can anybody help me to aware about the different wildcard characters available in the SQL?

Your help will be greatly appreciated..

[MindSpace]

Following are the different Wildcard characters which are available 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.


Please try to use these wildcard characters.

[Modifier]

Wildcard characters are essential to replacement for another string or character.

I)Asterisk(*): This Wildcard character replace more than one alphanumeric characters .

e.g:
m*n*:This Wildcard character can be match Matches mean, modification, man, management.

II)Question mark(?): This Wildcard character replace only one alphanumeric character.

e.g:
flash?:This will match any string which comprises six characters.

[Praetor]

Generally in the regular expressions we use Wildcard characters. These characters represents only one or may characters.The type of wildcard character is meta character.

Wildcard character are very useful while searching file in the many similar named files from directories of files.

Example: If you want to search files of which their names starts with "ASD", then you can use "*" wildcard character as "ASD*".

I hope this information will helps you.