Selecting X no of characters from 1 field to update another

[DavidAC]

I have a table which has a full post code field in it. This field will then be used to update another field POSTCODE1 but i only need to take either the the first 5 or 6 characters including spaces from the original field to do the update.
any help would be appreciated

 

[Russell Hauf]

Re: Selecting X no of characters from 1 field to update anot

Look up the LEFT function in Help. If you need more help, please expand on what you're trying to do.

Thank you,

Russell

 

[DavidAC]

Re: Selecting X no of characters from 1 field to update anot

Hi i currently have a field which contains post codes. I now need to be able to strip these post codes down to the initial 5 and 6 characters and update this information to another field whilst leaving the original post code in tact.
EG) POST_CODE SHORT_POST_CODE
DL17 8DD DL17 8
HG8 1AA HG8 1
i can use left trim to show the first 5 or 6 characters of the field but if i update directly from this it updates all other postcodes so ends up giving me HG8 1A as a example. i need to know how to speicfy only the first 5 or 6 characters in the POST_CODE table in order to run the update query successfully.

ray:

 

[smozgur]

Re: Selecting X no of characters from 1 field to update anot

You can try this :

Left([POST_CODE],InStr([POST_CODE]," ")+1)

in "Update To:" field in your query.

Suat

 

[DavidAC]

Re: Selecting X no of characters from 1 field to update anot

Thanks for that i have run it and it is working. thanks for your help.