1 (edited by timlitw 2015-02-18 16:42:25)

Topic: I have a sql populated tablegrid

I have a sql populated tablegrid, there is a field in the table that is 1 or 0 and I would like to show it as yes or no in the grid - is this possible in the sql or as an option to the grid?  where do I look for this information?

Re: I have a sql populated tablegrid

Example, where isSmoke is boolean field:


SELECT 

firstname,
lastname,
(CASE WHEN isSmoke=1 then 'Yes' else 'No' end)

FROM TableName
Dmitry.

Re: I have a sql populated tablegrid

Thanks!  trying now.