I have a query that gets the orders_delivery_name. I need to split it into two strings (FIRST,LAST). I was going to query the customer table but I need the delivery name. I am thinking just get everything up to the first space and assign that as the first name and everything after the space assigned as last name. Any thoughts on how to code this?
Steve



