Inserting a blank space in a string

[cosmos33]

Hello.
I got a table which contains a field named :ZipCode

Its a canadian zip code, so they are like this : H3S 2G4.

For some reason the users entered the code without the blank space in the middle. And I was wondering which query would
transform all row so that they would be separated after the third char with a space.

[trex005]

It is generally better practice to remove all optional formating before inserting into the database and then adding the formating when displaying, to cause more consistancy, and to make comparing simpler. in this case, to remove the space you could use the PHP :

$zip_code = ereg_replace(" ", "", $zip_code);

then in the places you want to display it you could use many different formating tricks... for example all strings can be treated as arrays :

$zip_code[0]$zip_code[1]$zip_code[2] $zip_code[3]$zip_code[4]$zip_code[5]