removing unwanted dashes

  • Thread starter Thread starter bird lover
  • Start date Start date
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
 
UPDATE TableName
SET FieldName =
Replace(FieldName, "na-", "na", 1, 1, 1);
 
Back
Top