Replace

[Gismo]

Hi all,

I want to replace all records with a "-" to no spaces starting with AS350A

AS35A012-345-78 to AS35A01234578

Please advise ho to use like with a replace statement

 

[arnelgp]

use Replace() function:

if you want to Update the field, use Update query:

Update yourTable Set theField = Replace(theField & "", "-", "");

 

[Uncle Gizmo]

use Update query:

Make backup first! This can't be undone...

 

[Gismo]

use Replace() function:

if you want to Update the field, use Update query:

Update yourTable Set theField = Replace(theField & "", "-", "");

Thank you

 

[Gismo]

Make backup first! This can't be undone...

This is a temporary file so should be ok but thank you for the advise

One record at a time

 

[Uncle Gizmo]

thank you for the advise

It's easy to forget the backup step, especially when you are trying something new... Caught me out more than once!

 

[Gasman]

I would even do a select first to see what I get, before even trying any update query.

 

[CJ_London]

arnel's suggestion does not quite meet your requirement

Update yourTable Set theField = Replace(theField & "", "-", "") WHERE theField Like 'AS350A*'