Hallo,

I have following problem.
I have an mysql-query and would likte to use it now with interbaseSQL but it does not work. I get an error in the if-statement.
It look like this:
SELECT
IF(wert<0,wert,0) SOLL,
IF(wert>0,wert,0) HABEN
FROM tabelle

What do i have to change that this query works with Interbase?

Thank You

Tobias