Hi Good Guys,
I need your help, Please help me.
I am trying to retrieve data from SQL SERVER 2000 Table, TBLSupplier whose ActiveStatus datatype is BIT which consist of value 0 (zero) or 1 (one). to display on the VBNT2008 DataGridView.
But the SQL String Select statment is not working.
Incorrect syntax near '='
Select SupplierId, SupplierName, IIF (ActiveStatus =1, 'YES', 'NO') as [Status] from TblSupplier
View Complete Post