How to retrieve account records where the name starts with "comp"?
Select Id,Name From Account Where Name Like 'comp%'
Does the above query guarantee at least 4 characters in length?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communitythe expression 'comp%' will bring everything that starts with 'comp' and ends with anything
if you want to always guarantee 4 letters after 'comp' you can use it as follows LIKE 'comp____' use 4 underscore to ensure 4 characters after 'comp'
comp