remove * from text in access table field
Posted on 2008-10-24
I need to remove the * from text stored in access table the field is called Product Description. The text should read like normal text without the *'s
An example of text is as follows
*First appearance counts, and with the Lincoln Coat Care range there is everything for the caring horse owner. *From classic shampoos to revitalizing washes, Lincoln cares deep down for your horses appearance and ensures a healthy coat and skin. *Helps remove grass and manure stains. *This product has been formulated to help eliminate yellow manure stains and grass stains. *It can be used as part of a general coat care and show preparation routine or for spot cleaning last minute unsightly stains.
Can you suggest a query to do this?