Boolean extract from EasyMorph vs. SSMS (SQL Server Management Studio)

1

Hi Community,

I have a very simple extraction from SQL server, in the SSMS (SQL Server Management Studio), value show as 0 or 1, while EasyMorph is showing as False or True.

How could I make EasyMorph to show as the same as SSMS?

Thanks!

image

image
image1131×654 20.4 KB

2

Hi @Cambridge,

You can either use the following SQL expression in the Query editor:

CAST([Discontinued] AS INT)

or add the "Modify column(s)" action with the following expression:

IF([Discontinued], 1, 0)

3

Thank you @andrew.rybka :slight_smile: