removing star character

[Ruegen]

Someone using our database has added the star character in a memo field for a bunch of records which we do not want

how would I use the correct replace() function to remove the star?

how do I even search for records containing * and not refer to it as a wildcard?

[Ruegen]

sorry fixed

Replace([ShowFeedBackMemo],Chr(42),"")