Replace (1 Viewer)

Gismo

Registered User.
Local time
Today, 17:21
Joined
Jun 12, 2017
Messages
1,298
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

..forever waiting... waiting for jellybean!
Local time
Today, 23:21
Joined
May 7, 2009
Messages
19,175
use Replace() function:

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

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

CJ_London

Super Moderator
Staff member
Local time
Today, 15:21
Joined
Feb 19, 2013
Messages
16,555
arnel's suggestion does not quite meet your requirement

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

Users who are viewing this thread

Top Bottom