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);
 
Top