>The problem is they are not in a discreet field. My client has insisted that they be put in the last line of the address and wants the rest of the data held as PROPER() case

I'm not familiar with Canadian ZIP Codes, but do you have a lookup table of all valid combinations???