Is there a less than sign in LO base?

[CeeGee]

I want to find out all the items in a database that are priced at less than one dollar. How do I write the query in LO base?

[Ratslinger]

Hello,

< is correct. You must have something else incorrect. Please post a sample Base (no personal or confidential information) file in your question or the SQL you are using and the field types used in the statement.

Example:

Select * from "Table" where "Amount" < 1

[CeeGee]

I tried using < but it didn’t work

[Ratslinger]

Answers are to actually answer the question. Please delete & add to original question (use edit) or add as comment.