I have an odd situation. I wish to select the value of a bit field in my MS SQL query. I want to know if it is true or false (1 or 0), but my query seems to somehow converting all the responses (true or false) to the letter 'A'. I want to know what the bit value is: true or false.
Here is the query:
INNER JOIN dbo.roles
ON dbo.members.pk_id = dbo.roles.fk_member_id
INNER JOIN dbo.teams
ON dbo.roles.fk_teambar_number = dbo.teams.pk_id
WHERE ( dbo.roles.fk_teambar_number = @FK_TEAMBAR_NUMBER )
AND ( dbo.roles.TYPE = 'Player' )
Why is it converting all TEAMS.ACTIVE date to the letter 'A' for both true and false ??? I bind the results to a gridview and both true and false are listed as an 'A', and I get the same thing where I run the query in my GoDaddy query analyzer. Does anyone have an idea how to fix this?
View Complete Post