Hello:

I'm having problems trying to CAST a value to VARCHAR (Firebird 1.5.0.4306):

SELECT * FROM "TEST" WHERE CAST('' AS VARCHAR) IS NULL

or

SELECT * FROM "TEST" WHERE CAST(? AS VARCHAR) IS NULL

Gives this error:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, char 47.
).

Is this the expected behavior ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain