I am not sure how to technically explain this so please bear with me. I am trying to make a change where one of the columns has data that is returned from a query that puts two groups of numbers in it. Here is what the data looks like in the field.
the field name is client_id in table ups
So how do I get to remove all of the data and blanks left of the second group of numbers?
This example would be:
I thought of doing a this:
SELECT LEFT('XXXXX', 5);
but dont think this is correct first of all can you do a LEFT with wildcard?
Then I would just do a trim after that to remove the blank space.
Any suggestions would be greatly appreciated. And if this is right. Why is it not working?
Thanks in advance.