sheriey

 Profile Answers by sheriey 

• Nov 28th, 2007

 

Use % as a wild card anywhere

r.jain

 Profile Answers by r.jain 

• Nov 20th, 2008

 

Wild card character can be used in query with Matchs pattern and Different from pattern operator.

lionskashif

 Profile Answers by lionskashif 

• Feb 17th, 2011

 

hi,

like operator will help you to allow wild card character in a query

for example: you want to find a name "Muhammad kashif" in the name column.

but you dont know "Muhammad" Start by "Mo" or "Mu" So, you use wild card

such as you write in query 

where name like "M_hammad" ("_" for find the single character)

and 

where name like "M%" ("%" First char is M rest is whatever)

these two wild card characters we use in query.

hope it help........... goog luck