J jumydar Feb 9, 2009 #1 i want to delete from the familyname field the first two characters if it start with GF fr examle
T Tom van Stiphout Feb 11, 2009 #2 On Mon, 9 Feb 2009 14:14:02 -0800, jumydar if I understand you correctly you'd want an UPDATE statement like this: update myTable set FamilyName = Mid(FamilyName, 3) where Left(FamilyName, 2) = 'GF' -Tom. Microsoft Access MVP
On Mon, 9 Feb 2009 14:14:02 -0800, jumydar if I understand you correctly you'd want an UPDATE statement like this: update myTable set FamilyName = Mid(FamilyName, 3) where Left(FamilyName, 2) = 'GF' -Tom. Microsoft Access MVP
