hi guys, what is the meaning of this expression?
LENGTH({trackingnumbers}) = 12 AND {trackingnumbers} LIKE '7%' THEN 'FedEx'
t
Tyn Guardian
04/18/2022, 7:20 AM
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
pen one
04/18/2022, 12:52 PM
As an aside - not all FedEx tracking numbers start with 7.