Access Query last character omitting -

Access Query last character omitting -

i want write query on run compare 2 string excluding lastly charater. eg. have in database newyorka, in search text want search excluding in last, i.e newyork how can write in query.

try this:

select left(columnname, len(columnname) - 1) allcharsexceptone tablename

access-vba