Hi all.
I'm wondering if some of you sql experts can help me create a query to single out a value from an item code. The item code looks like this "name fabric color size" the number of spaces (parameters) is always 4 but number of characters in the different parameters is dynamic.
I would very much like a query that gives me the size parameter in its own column - like this:
"name fabric color size" | "size"
Can this be done with a query?
Appreciate all help.
Best regards, Runar Wigestrand.