Conditional Function

Wausserla

• December 12, 2022 13:17

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

Vote

0

• 

  Geoff Booth

  • December 13, 2022 17:07

  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

Please sign in to leave a comment.