I am using a datagrid and one column is a boolian value. My SQL statement works fine, but I want to display 'TRUE' or 'FALSE' in the column instead of '0' or '1'. I think that I need the CONVERT() function, but I don't know the syntax to use. Does anybody know how to do this?

Hello,
You can do it by many ways...
One of them is---->

mysql> select if(1,'true','false');
+----------------------+
| if(1,'true','false') |
+----------------------+
| true |
+----------------------+
1 row in set (0.03 sec)

mysql> select if(0,'true','false');
+----------------------+
| if(0,'true','false') |
+----------------------+
| false |
+----------------------+
1 row in set (0.00 sec)

Regards
Milind