Re: Can this be done in SQL?

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Yes, it can be done, probably in lots of different ways. 
One sample: treat the file as five files like

select  ***cust data, parts not reapeted***, model1 from file as a  ... 
where ....
union all
select  ***cust data, parts not reapeted***, model2 from file as b  ... 
where ....
union all
select  ***cust data, parts not reapeted***, model3 from file as c  ... 
where ....
...

Adam West wrote:

> HI I have a file that it is a customer purchase file, they hold up to 5 items that were purchased and each record has the five items,model1, model2, model3, etc most of the time the last 4 are blank.
>
> The need arose to produce a picking list by model number ordered rather than by invoice number which was easy enough to do, by making a logical on model1. however, there are sometimes promotions where if you purchase model A you get a free Model Z. This model Z is often gets placed as Model1 which obviously throws off the sort because the main partof the order would be model2 in that case. 
>
> I was wondering if in SQL I could do a shift if model1 = say 'Freebatteries' make model1 = model2 and model2=model1.
>
> I have little control of this incoming data as it is a feed from an outsourced web site. So I have to do the reshuffling.
>
> it could be done via a small RPG program but maybe in SQL it is faster and something to learn for me.
>
>
>
>
>      
>