Update Criteria data ONLY

[jempie]

Hi all,

I've tried searching the forum, but no luck.

I have a Field say Field1, with data like this:

AB, AC
AB
AC
AB, AD
AA, AB

Where the field contains "AB", I want to replace the data with say "AB - Alpha Beta". But I do not want to change any of the other data. So the outcome should look like:

AB - Alpha Beta, AC
AB - Alpha Beta
AC
AB - Alpha Beta, AD
AA, AB - Alpha Beta

I'd then go on to change AC to say "AC - Alpha Charlie".

All help appreciated,

Jempie

 

[Mile-O]

I have a Field say Field1, with data like this:

AB, AC
AB
AC
AB, AD
AA, AB

Are you saying that one field holds the values AB and AC? If so you need to look at your design again before you go any farther as this breaks the very first rule of database design in that all row by column values should be atomic/indivisible.

 

[jempie]

Yes, i'm afraid so.

I've been given a flat file and the data needs to stay in the same field.

I'm sure someone on here told me how to do it before, but I've slept since then!