Update Query Adding "*" to a field

[chubby]

I'm trying to add "*" the beginning and ending of a field that contains 1233 record.

Field: comparment
Table: tbl_compartment listing
Update to: *
Criteria: At the begining and end of each record

Example: 4-77-0-C
What I need *4-77-0-C*

 

[steven290]

i think its someting like, sure if its + or &

update tbl_compartment set listing=('*' + listing + '*') where id=something

 

[chubby]

I'm using the QBE and I try this and it did not work.

 

[steven290]

weird it worked for my, show your sql