select filed1, field2, ;
IIF(field3=1, "VALIDATE ", "INVALIDATE") AS cField3 ;
from table1
>Hi all,
>
>I have a list_box with 3 columns and X lines.
>I passed a sql command like :
> select filed1, field2, field3 from table1
>
>My question is :
>
>the value of field3 is only 0 or 1
>
>How can I change the value of field3 in the list_box (or in the sql command)
>to show VALIDATE, in the list_box, if field3 = 1 OR INVALIDATE if field3 = 0
>
>thx
--sb--