My Visual Database — I have a sql populated tablegrid

Re: I have a sql populated tablegrid

null@example.com (timlitw) — Wed, 18 Feb 2015 17:26:43 +0000

Thanks! trying now.

Re: I have a sql populated tablegrid

null@example.com (DriveSoft) — Wed, 18 Feb 2015 17:06:32 +0000

Example, where isSmoke is boolean field:

SELECT 

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

FROM TableName

I have a sql populated tablegrid

null@example.com (timlitw) — Wed, 18 Feb 2015 16:41:55 +0000

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?