Solved

remove * from text in access table field

Posted on 2008-10-24
1
287 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 34 79
Sub Reports 8 21
Getting the Error "User-defined type not defined" in MS Access 2013 16 37
SQL Statement to Update Email Domain 2 19
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

932 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

20 Experts available now in Live!

Get 1:1 Help Now