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