IF ELSE STATEMENT WITH LIKE Condition

[kathbanc]

Hi! 

Please help me, what is the syntax for like in IF ELSE Statement. 

IF [SLoc] like 'PA%' THEN '234'
ELSE [SLoc] ENDIF

This one is error 

Thank you 

[gawa · Accepted solution]

hi @kathbanc 

StartsWith and/or EndsWith function can be used for equivalent statement to LIKE in SQL query.

If you want to match the beginning of words, use StartsWith().

StartsWith([SLoc], "PA")

 Or, If you want to match the end of words, use EndsWith(). 

EndsWith([Sloc], "PA")

[kathbanc]

Thank you @gawa it works!! Thank you so much