I have a column of data similar to the following:
A12312-01
A12445-02
W34323-01
A34298-01
W54732-01
and so on.
I am querying all of this from a database with MSQuery.
I need to take all instances that start with "W" and truncate the "01" from the end. If the value does not start with "W", the suffix "0x" must remain.
Thanks for helping a newb!
A12312-01
A12445-02
W34323-01
A34298-01
W54732-01
and so on.
I am querying all of this from a database with MSQuery.
I need to take all instances that start with "W" and truncate the "01" from the end. If the value does not start with "W", the suffix "0x" must remain.
Thanks for helping a newb!