Insert

[CM670]

Hi,

I have a table which holds the status of peoples orders. It holds information on order_id
order_status
order_desc
letter.

Different letters are printed automatically according to the status of the order.

However when the status is 'Dispatch' i need two letters to be printed.

I have tried

Insert into orderstatus (order_id,order_status, 
order_desc, letter) values('025', 'Dispatched', 'Black tailored coat ','DPTdoc DPT2doc');

This only prints the first letter, (the DPTdoc) but not the second (DPT2doc).

Does anyone have any ideas on how to fix this?

Thanks!

[guelphdad]

Yes, normalize your data. Multiple values do not belong in a single column.