January 21, 2008 at 3:17 am
Guys,
My derived column object is converting the bit column in my database to a true/false value. I need this to reamain as 1/0.
What is the best way of achieving this? Is there a preference I can set or should this be done via an expression?
I have tried changing this at every stage of the way but either get no change or obscure results.
Thanks guys,
Joe
January 21, 2008 at 5:39 am
A bit field is really True/False much more than it is 1/0. If you want to change it's data type, you can either use a data conversion or a derived column component to change it to a numeric data type. If you convert it to an integer of some sort (whatever size you feel like using will work) it will appear as 0 or non-zero (usually 1). To be truly safe, using a derived column and actually checking if the value is false will be the best approach.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply