Skip to Content
0
Former Member
Apr 27, 2009 at 01:43 PM

Substring query

71 Views

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.