prasuna

• Nov 18th, 2005

 

For single charecter _

For multiple charecters %

if the charecter is one from this list then []

if the charecter should not contain this means ^(not operator)

pujavipin

 Profile Answers by pujavipin 

• Jun 4th, 2009

 

% = for matching one or more characters.
_ = for matching excatly one character.
[abc]= for matching either 'a' or 'b' or 'c'.
[^abc]= for matching character other than 'a','b'and 'c'.

Bhuvaneswari.V

 Profile Answers by Bhuvaneswari.V 

• Aug 22nd, 2009

 

_ for matching single characters
% for matching mutiple characters
[] for matching either characters
[^] for not matching character

eg
Table having a column name then
Name LIKE 'A_' returns the name start with A and only one character after 'A'
Name LIKE 'A%' returns the name starts with A.
Name LIKE '[AB]%' returns the name starts with A OR B
Name LIKE '[^AB]%' returns the name starts with other than A & B