>Dear readers,
>
>When i execute the folowing SQL query, i get the error colomn "WTG"not found.
>
>SELECT detail.avr_ari,;
> iif(Detail.avr_wtg=.t.,'J','N') as WTG;
>FROM general!detail;
>WHERE WTG='J'
>
>Is this an impossible kind of query, to include an expressionalias in the WHERE Clause ?
>
>Any idea's how to solve this ?
>
>- Bjorn

You have to specify the field name in the WHERE clause.

SELECT detail.avr_ari,;
iif(Detail.avr_wtg=.t.,'J','N') as WTG;
FROM general!detail;
WHERE avr_wtg=.T.

But why even use the IIF() if you only want the ones of a particular value?


SELECT detail.avr_ari, "J" as WTG ;
FROM general!detail ;
WHERE avr_wtg = .T.