Moving the end of one field to another

[Phil]

Hello,

I have a table with 2 columns called catcode and prodcode and an example
would be like this:

catcode | prodcode

home-frag-cd | H-ACP1003
lighting-cd | H-AR1009
bed-candles-ys | H-BSC1005
What I need to do is take whatever comes after the last "-" in catcode and
add it and the "-" to the end of prodcode. So the result on the above
would be:

catcode | prodcode

home-frag-cd | H-ACP1003-cd
lighting-cd | H-AR1009-cd
bed-candles-ys | H-BSC1005-ys

If it helps, the last 3 characters of catcode are always the "-" plus the
suffix that needs to be moved.

How can I do this?

Thank you.

[Fredg]

Phil,
I'll take you at your word that the last 3 characters are always -XX.

You can make an update query to permanently add the last 3 characters of one
field to the other field.

Update YourTable Set YourTable.ProdCode = ProdCode & Right([CatCode],3);

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Phil" <ph**@hoobermedia.com> wrote in message
news:0GQub.190152$9E1.1011826@attbi_s52...

Hello,

I have a table with 2 columns called catcode and prodcode and an example
would be like this:

catcode | prodcode

home-frag-cd | H-ACP1003
lighting-cd | H-AR1009
bed-candles-ys | H-BSC1005
What I need to do is take whatever comes after the last "-" in catcode and
add it and the "-" to the end of prodcode. So the result on the above
would be:

catcode | prodcode

home-frag-cd | H-ACP1003-cd
lighting-cd | H-AR1009-cd
bed-candles-ys | H-BSC1005-ys

If it helps, the last 3 characters of catcode are always the "-" plus the
suffix that needs to be moved.

How can I do this?

Thank you.