Adding a string to the end of a field

[Scootynm]

I have a field that contains various text....(It's a note field that allows 86 characters).

I want to go in to the database and add the string "Conversion 2007" to the end of every record. So leave whatever is in there but add in the string. I would like it to add whatever it will fit, in the cases where there is not enough room.

I figured this was somewhat simple, but I haven't found anything yet.
Thanks.

 

[Scootynm]

I got it

In the Update box I put [fieldname] + " CONVERSION"


Seemed to do the trick.

 

[RuralGuy]

How about:
[YourField] = Left([YourField] & "Conversion 2007",86)

 

[Scootynm]

That did it

Looks like that worked too. Thanks!

 

[RuralGuy]

Have a good day.