removing unwanted dashes

B

bird lover

I use access 2003. field [indexer] has many records containing
na- 2008-3456

What is syntax in update query to remove first dash, so it looks like
na 2008-3456
 
K

Ken Snell \(MVP\)

UPDATE TableName
SET FieldName =
Replace(FieldName, "na-", "na", 1, 1, 1);
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top