how to use wildcards for Soql in salesforce?

Hi Vikas,

The % and _ wildcards are supported for the LIKE operator.

• The % wildcard matches zero or more characters.
• The _ wildcard matches exactly one character.

For example in your case, if the accounts in your org have the following names:

{Direct, ReDirector, UnDirects, UnDir, Dir}

The first query returns: Direct, ReDirector, UnDirects, UnDir

The second query returns: Direct, Dir

The third query returns: Direct

Hope this helps.