Solved

remove * from text in access table field

Posted on 2008-10-24
1
286 Views
Last Modified: 2010-03-20
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?
0
Comment
Question by:oldmillsaddlery
1 Comment
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 250 total points
ID: 22799220
UPDATE SomeTable
SET SomeColumn = Replace(SomeColumn, "*", "")
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server 2008 R2 - Execution Plan 3 28
Access Date Query 28 29
Dateadd 3 20
Conditional Formatting - Date() 8 24
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now