Comparing Logical Values in Stored Procedures 1

[laado]

Hi Friends
In a Stored procedure when using Select
Can i do something like this
If tableName.FieldName is 1
Output = Yes
else
Output = NO

Thanks in Advance

 

[vganeshbabu]

U Can use CASE statement inside the select command..

Example

Select Name, Case Gender When 'M' then 'Male' Else 'Female End from employee

(A star please if this helps u)..