Re: [Hsqldb-user] Left Function

[fredt <fr...@us...>]

Use SELECT "LEFT"(employee_name). The engine interprets LEFT as a keyword
used for joins.

----------------------

Andrew Barilla wrote;

I'm now trying to use the LEFT function in a select statement:

The following statement gives me a syntax error:

SELECT LEFT(employee_name)
FROM employees

but these work...

SELECT RIGHT(employee_name)
FROM employees

SELECT LCASE(employee_name)
FROM employees

Am I missing something obvious here?