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

On Mon, 9 Feb 2009 14:14:02 -0800, jumydar
<jumy***@discussions.microsoft.com> wrote:

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



Show quoteHide quote

How to move a secure Db from one laptop to another
Workgroup Information File
expressions blocked inconsistently
Encrypt only Back-End in Split DB
Ping Chris O'C
How to hide database window in Access 2007
access to edit form but not change form
create login screen with db2
Can't run dynamic crosstab queries after setting up security
Installing DB on a server/accessing it from a client PC