Replace asterisk Query error

[justme]

UPDATE TEST_Table AS T SET T.Comments = Replace([Comments],"*","")

Error I am getting is cannot update due to conversion type failure.

Comments is a memo field.

Many fields are empty. Some fields contain just text. Many fields look like
this:

***These are the comments in the box


I want to get rid of asterisks, regardless of how many are in the comments
field.

Error I am getting is cannot update due to conversion type failure.

Thank you!

 

[fredg]

UPDATE TEST_Table AS T SET T.Comments = Replace([Comments],"*","")

Error I am getting is cannot update due to conversion type failure.

Comments is a memo field.

Many fields are empty. Some fields contain just text. Many fields look like
this:

***These are the comments in the box

I want to get rid of asterisks, regardless of how many are in the comments
field.

Error I am getting is cannot update due to conversion type failure.

Thank you!

Update TEST_Table SET Test_Table.Comments = Replace([Comments],"*","")
Where Test_Table.Comments is not null;

 

[justme]

GENIUS!
THANK YOUUUUUUUUUUU!!! THANK YOUUUUUUUUUUU!!! THANK YOUUUUUUUUUUU!!!