Code Question
How do I.I have a DB with two tabels I need to update CustomerOrder from CustomerOrderHeader where data in the "Shopadress" ex. (Nordre Strandvej 19) field have to be splitted into two fields "RoadName" ex. (Nordre Strandvej) and "HouseNo" ex. (19) in CustomerOrder. It would perfect if this could done in a Query.