SQL bit formate convert

[song403]

In SQL, there is a bit data format which stands for true or false. I fetch this data from SQL server. however, after "Variant to Data". it is display as -1 or 0. how can I force them show "true" or "false".

[GerdW]

Hi song,

use comparison function "<0". Or better compare with <> "0" as you read strings…

It would really help to crop your images before uploading them!

[Ranjeet_Singh]

What image you posted is the image of SQL or your table? Also why dont you use database to varient?

Also ensure whenever you post any image we dont have to use microscop to see