I have SQL that i pull every day:
select OriginLocation from load;
The problem i have is that the cell content is:
In the cell, i have 2 commas.
I want to query only what in the middle of the 2 commas.
If i have 4,201011222100,20139
in the cell, i want to only pull 201011222100
If i have 3,03,15634
in the cell, i want to only pull 03
The number of chars can vary between the 2 commas.
How can i do this?