JeffMachine
MIS
I have a field whose data looks like this:
003391
003391-01
003391-01-01
002498-02-01
004895-02
004895-02-01
005523-01
I would like to have a query that returns "Warranty" for lines 3,4 and 6 and nothing for the others.
Warranty items end in "-01" but only after the second dash. So lines 2 and 6 are not warranty items.
Thanks ...
003391
003391-01
003391-01-01
002498-02-01
004895-02
004895-02-01
005523-01
I would like to have a query that returns "Warranty" for lines 3,4 and 6 and nothing for the others.
Warranty items end in "-01" but only after the second dash. So lines 2 and 6 are not warranty items.
Thanks ...