Activity Forums Salesforce® Discussions how to use wildcards for Soql in salesforce?

  • Kumar

    Member
    January 5, 2017 at 8:47 am

    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.

     

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos