+ Start a Discussion
craigmhcraigmh 

Bappl

I have a quick question about the Comparison Operators documentation. I just wanted to make sure I wasn't going crazy. On that page, I saw this example under the LIKE operator:

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_comparisonoperators.htm

 

For example, the following query matches Appleton, Apple, and Bappl , but not Appl: 
SELECT AccountId, FirstName, lastname FROM Contact WHERE lastname LIKE 'appl_%'

 

Looking at this example, I can't see why Bappl would match. Not only is there no wildcard for the "B", but there is no character after the "l" for the underscore wildcard. Am I completely missing something, or is this simply an oversight in the documentation?

SuperfellSuperfell

You're not going crazy, the doc is wrong, I'll see about getting that fixed.