Need to have all PostCodes put into a standard format before putting into the DB.
I suggest - remove all white space (before, middle and after).
validate as a post code
make upper case and put a single space in the middle
(actually, the standard for printing is to have 2 spaces in the middle but we will go for 1 for the DB).
(actually there are only 2 fields - client address & supplier tables)
Need to have all PostCodes put into a standard format before putting into the DB. I suggest - remove all white space (before, middle and after). validate as a post code make upper case and put a single space in the middle (actually, the standard for printing is to have 2 spaces in the middle but we will go for 1 for the DB). (actually there are only 2 fields - client address & supplier tables)