How do I modify text with a query

[Guest]

I have a database that has a text fied with numbes such as 123-45-6789 I
want to remove the dashes with an update query. How do I do this

Thanks
Tim

 

[Guest]

Replace([YourTextField],"-","")

 

[Jeff L]

Easier way:
Select YourFieldName

From YourTableName

Where YourFieldName Like "*-*"

Run the query and do a search and replace.

 

[Guest]

Easier way:
Select YourFieldName
Where YourFieldName Like "*-*"

Run the query and do a search and replace.

I have tried both of these and can't seem to get it to work.

I tried Replace([YourTextField],"-","") in an Update Query and it deleted
everything

The I tried the Find & Replace dialogue box with Find "*-*" and Replace with
"**" this gave me ** in every record

Did I do something wrong?

 

[Jeff L]

Yes. I said run the query, THEN do the search and replace. Search for
- and leave the replace field blank.

Easier way:
Select YourFieldName
Where YourFieldName Like "*-*"

Run the query and do a search and replace.

I have tried both of these and can't seem to get it to work.

I tried Replace([YourTextField],"-","") in an Update Query and it deleted
everything

The I tried the Find & Replace dialogue box with Find "*-*" and Replace with
"**" this gave me ** in every record

Did I do something wrong?

 

[Guest]

Yes. I said run the query, THEN do the search and replace. Search for
- and leave the replace field blank.

Easier way:
Select YourFieldName
From YourTableName
Where YourFieldName Like "*-*"

Run the query and do a search and replace.

I have tried both of these and can't seem to get it to work.

I tried Replace([YourTextField],"-","") in an Update Query and it deleted
everything

The I tried the Find & Replace dialogue box with Find "*-*" and Replace with
"**" this gave me ** in every record

Did I do something wrong?

Tim c wrote:
I have a database that has a text fied with numbes such as 123-45-6789 I
want to remove the dashes with an update query. How do I do this

Thanks
Tim

GOT IT, THANKS FOR YOUR HELP