RE: [baseball-databank] database and openoffice
Why not using >,<,=,>=,<=,<> instead of ‘like’ operator? Like operator is normally used for strings values.
Ex. Select * from batting 3B > 23 …. Also you might need to enclose the 3B or 2B fields between  … like, Select * from batting where [3B] like 23
Is anyone using openoffice with the Lahman database?
I am having issues when I try to make a query with the 2B and 3B data, getting errors that I do not understand...
where 3B like 23
gives the following error
SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
what am I missing?