I have a table (inherited) which I cannot change but which stores a postal address in a single field with line breaks (for readability I presume).
I want to create a query/view in SQL that will create separate "fields" for each line in the address.
eg: strAddress =
"34 West Road
strAddress1 = "34 West Road"
strAddress2 = "Little Villas"
strTown = "MyTown"
strPostCode = "AA1 1AA"
(field names are examples only).
I am OK with most SQL but this has gone above my head and my searches have found lots of potential answers but nothing close enough.