hide the first two specific characters of the value of a field

[jumydar]

i want to delete from the familyname field the first two characters if it
start with GF fr examle

 

[Tom van Stiphout]

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