Copy part of a record as value in another field

[surferxx]

Im using the UPDATE Query in Access

UPDATE MAT_Clean SET FCODE = 'BC', NOTES = 'HC RAMP'
WHERE FCODE='BC HC RAMP';

Instead of typing what needs to go into NOTES everytime, how can I specify whatever comes after 'BC' to go into NOTES? Use 'BC *'?

Thanks!

 

[KeithG]

Is BC always the first two characters?

 

[surferxx]

Yes!...Its 'BC HC RAMP' or 'BC @ FL' or so on

 

[KeithG]

try

mid([FieldName],3,(len([FieldName])-2))

 

[surferxx]

amazing Keith!. exactly what I wanted!. can you explain that statement to me in detail please and how its doing what its doing?

 

[surferxx]

Ok no need!, I got it!. Thanks a bunch Keith!