By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

Replacing * from Access data

P: 8
Hi,
I want to replace * with space in the MS Access data.
And i tried to use the Find and Replace option,but for all other chacters its working.but for * its not working.

Can anybody help
Apr 16 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi Mary. **EDIT** Ah, you may be using the find and replace menu options. As far as I can tell you cannot find and replace wildcard characters using the built-in menu options.

However, there is a Replace function which can do the string replace for you - check it out. You will need to build it in to an Update query to use it, however.

In testing Replace you can refer directly to the asterisk character and it will work fine in an update

=Replace (OldString, "*", " ")

or you can use the ASCII character equivalent

=Replace (OldString, Chr(42), " ")

-Stewart

Hi,
I want to replace * with space in the MS Access data.
And i tried to use the Find and Replace option,but for all other chacters its working.but for * its not working.

Can anybody help
Apr 16 '08 #2

P: 8
Thanks Stewart,,Anyway i got the same answer before itself..nyway thanks for the help...
Apr 17 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.