This content has been marked as final. Show 7 replies
I am trying to use Postcode lookups to add an area to the data I am analysing.
If I use Left string I get most of the fields matched up but I need to remove the text after the space in the post code to get a full match.
Eg Left 4 on N1 4TH will not match to N1 as it is coming over as N1 4 which isn''t a match to my postcode lookup
If I use Left 3 I will not match the postcodes that are 4 digits eg NN44
Anyone know how to strip the text after the 1st blank space...I am thinking of using length upto the space then using this as the left statement.
Thankyou for any assistance you can offer.