I need to change 1000 records which are postcodes, from full postcodes ie;NN17 2NZ to short post codes ie:NN17 2 whilst keeping the full postcodes intact. Please help

Instead of changing anything why not just display the short Post Code using the long Post Code? Assuming ALL Post Codes are in the format of XXXX XXXX then Left([PostCode], 6) will show you NN17 2.



[This message has been edited by Jack Cowley (edited 02-13-2002).]