Is there a way to have something like

SELECT
IF (CONDITION 3 ELSE 4) MYCODE
FROM TABLEA
WHERE MYCODE <> SOMEFIELD

IOW once I create mycode, to be able to use it just like any other column,
even something like

SELECT
IF (CONDITION 3 ELSE 4) MYCODE
FROM TABLEA
JOIN TABLEB ON TABLEB.FIELD = MYCODE

I suspect the answer is no, but who knows.

Robert

Rober

> IOW once I create mycode, to be able to use it just like any other column,
> even something like
>
> SELECT
> IF (CONDITION 3 ELSE 4) MYCODE
> FROM TABLEA
> JOIN TABLEB ON TABLEB.FIELD = MYCODE

The following should work

SELECT
IF (CONDITION 3 ELSE 4) MYCODE
FROM TABLEA
JOIN TABLEB ON TABLEB.FIELD = IF (CONDITION 3 ELSE 4)

John

Robert

The actual syntax for DBIsam is

SELECT
IF (CONDITION THEN 3 ELSE 4) MYCODE
FROM TABLEA
JOIN TABLEB ON TABLEB.FIELD = IF (CONDITION THEN 3 ELSE 4)

John

"John Hay" <j.haywithoutdot@crbsolutionsremoveallthis.co.uk> wrote in
message news:350500BE-BB01-4714-B65A-E74072501779@news.elevatesoft.com...
> JOIN TABLEB ON TABLEB.FIELD = IF (CONDITION THEN 3 ELSE 4)
>

Thanks John, that's what I've always done, I was looking for a way to
eliminate the restating of the IF clause.

Robert