Conditional Function

Wausserla

Can anyone help on this condition - want to 'Set' if the content of a particular field starts with 'Z'

IF STARTS WITH($[$143.38.1])='Z'
BEGIN
Set($[$38.1470002149.0]|60-20);
END

Comments

1 comment

Date Votes
  • Comment author
    Geoff Booth

    Try:

    @STORE1 = SQL(Select LEFT($[$143.38.1],1)); // Store the first character
    IF @STORE1 = 'Y' // Perform a direct comparison
    BEGIN
    Set($[$38.1470002149.0]|60-20);
    END

    0

Please sign in to leave a comment.