LinusIT - 9:14 pm on Mar 4, 2011 (gmt 0)

Thanks for the replies.

The delivery address is stored in the "orders" table and the products are store in orders_products.

The delivery address is on a single line and the products are on multiple lines.

Order ID is numeric.

I will try and implement your suggestion rocknbil, thanks.