query for removing text from the right

[paul69]

How do I create a query so that I remove text from the right. For example,
if I have the word flower, I want the query to remove 3 from the right to
make flo.

Thanks in advance, Paul

 

[Ken Snell \(MVP\)]

SELECT Left(FieldName, Len(FieldName) - 3) AS NewName
FROM TableName;