SQL SERVER 2000 DataType BIT

[lenniekuah]

Hi NeoPa

I am hoping that after all this incidents the helpers of this FORUM has to be sensitive to the statment they are making in order to make this FORUM AWESOME AND FRIENDLY. And also try to provide sample coding as solution and with explaination and suggestion. And the Moderator has to be fair to the Requester as well instead of just supporting the Helpers even if they made mistakes.

As for the sample coding or suggestions. I do not just accept it and logout. Once I got my coding working based on that I will post it here to share with other Newbies who may have similar problems.

[NeoPa]

I'm certainly happy with that Lennie.

Where are you now with your original problem?

[lenniekuah]

The working SQL String is based on the FORM program and I am posting it here earlier and now for other Newbies who may have similar problem. The SQL String is not based on SQL SERVER 2000 Stored Procedure or TranSact SQL.

Select SupplierID, SupplierName,  
(CASE Status when 1 then 'Active' Else 'NotActive' End) as [Status] 
From TblSupplier

--------------------------------------
Ths is my 2nd posting of working SQL String. The 1st working posting was on

Posts: 67
#9: 2 Days Ago