appending to end of Line description

[tmercier]

I am wondering if it is possible to use a wildcard in an update query. I would like to add text (the same word) to the end of the line item description where the starting text values are different.

example:
want to add Quantum

beginning value is:Trendsetter II -> new output value would be "Trendsetter II Quantum"

Lotem 800 -> Lotem 800 Quantum
8up -> 8up Quantum

 

[Moniker]

UPDATE Your_Field_Value SET Your_Field_Value = Your_Field_Value & " Quantum";

You can use a standard update query and just reference the same field and tag & " Quantum" to the end of it in the UpdateTo field.

 

[tmercier]

This is exactly what I was looking for! Thanks for the speedy response