C Chris Feb 26, 2004 #1 how do I update a mistake in a postal code entry from TR49D3 to TR4 9D3? I.e. include the missing space?
how do I update a mistake in a postal code entry from TR49D3 to TR4 9D3? I.e. include the missing space?
F fredg Feb 26, 2004 #2 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);
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 Feb 26, 2004 #3 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'
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'
