I have to select a value from a pick list having values starting with 'PR'

I have tried

ISPICKVAL(Order_Type__c, 'PR%')

But I am not able to use expression Like or wildcards here.

2 Answers 2


Use the Left formula along with the text formula and compare that to PR.

LEFT(TEXT(Order_Type__c),2) = "PR"

CONTAINS(TEXT(Exchanged_Through__c), 'QC')

  • 1
    i realize you answered your own question but the answer doesn't correspond to the question (starts with versus contains) - for others, you might want to align question with answer
    – cropredy
    Aug 9, 2014 at 19:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .