Showing results for 
Search instead for 
Did you mean: 

SQL bit formate convert

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".



0 Kudos
Message 1 of 3

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!

Best regards,

using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 3

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

Kudos are always welcome if you got solution to some extent.

I need my difficulties because they are necessary to enjoy my success.
0 Kudos
Message 3 of 3