Delete text string in Access query 1

[roselam]

How do you delete a certain text string (or if not that, then the last 6 characters of a field) using a query?

 

[Golom]

If you are talking about just changing a field value then

   UPDATE tbl SET fld = Left$(fld,len(fld)-6)
   WHERE Right$(fld,6) = "abcdef"

If you want to get rid of the whole record then look up the DELETE command.

 

[roselam]

Thank you! That worked perfectly!