hi guys, what is the meaning of this expression? L...
# general
a
hi guys, what is the meaning of this expression? LENGTH({trackingnumbers}) = 12 AND {trackingnumbers} LIKE '7%' THEN 'FedEx'
t
LENGTH({trackingnumbers}) = 12 --> you are checking how many characters that a trackingnumbers has ex: 001 will result to 3 {trackingnumbers} LIKE '7%' --> means to check if trackingnumbers starts with 7 Oracle / PLSQL: LIKE Condition (techonthenet.com)
p
As an aside - not all FedEx tracking numbers start with 7.
a
thank you 🙌