Ive been haded a DB with the customer firstname prepopulated. Good stuff! However, the data punchers have put the first name AND the second name in the same record.
I have to access the data through ODBC and have been told that I cannot change the record format to correct this (great!)
I'm using a query, because I have to (orders are orders) to call the customer data for a number of reasons one of which is marketing letters and leaflets etc. so I need to just use the first name of the 2 in the record. Simple I used