Change YN to Boolean

[mattyboy2000]

Hi,

I have a table in SQLServer that contains a Field called Monthly. It is a varchar(1) type field that contains 'Y' or 'N'.

In my VB Application I want to use it as a boolean. I want to do it via a SQL Stored procedure. I tried to do a case statement:

SELECT Ref as SettleCode, [Desc],
CASE SetMonth WHEN 'Y' THEN True
ELSE False
END as bolMonthly, SettDays, DiscPerc
FROM Settle

The problem is that True and False are not constants in SQL Server. I tried to return 0 or 1, but my program then saw them as integers


Any help or sudgestions will be greatfully recieved

Matt

 

[sguslan]

SQL has no Boolean data type. The closest is Bit type butit is basically TinyInt with only 2 possible values, 0 and 1 .. ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[mattyboy2000]

I guess my problem is the way .net interprets the values

I've solved it with a work around, but thanks for your help

Matt

 

[tlbroadbent]

SELECT Ref as SettleCode, [Desc],
CASE SetMonth WHEN 'Y' THEN 1 --or -1 as in VB
ELSE 0
END as bolMonthly, SettDays, DiscPerc
FROM Settle
If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm