Replace asterisk Query error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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!
Click to expand...

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