update query for postal code

C

Chris

how do I update a mistake in a postal code entry from
TR49D3 to TR4 9D3? I.e. include the missing space?
 
F

fredg

how do I update a mistake in a postal code entry from
TR49D3 to TR4 9D3? I.e. include the missing space?
Click to expand...

If the space is ALWAYS to be added after the 3rd character:

Update YourTable Set YourTable.[PostalCode] = Left([PostalCode],3) & "
" & Mid([PostalCode],4);
 
M

MGFoster

Chris said:
how do I update a mistake in a postal code entry from
TR49D3 to TR4 9D3? I.e. include the missing space?
Click to expand...

UPDATE TableName
SET PostalCode = 'TR4 9D3'
WHERE PostalCode = 'TR49D3'
 
Top