Posted by teresa on 12/04/06 18:09

Hi All,

I am pretty new to stored procedure and I have a quick question. I
appreciate any help offered.

I am writing a stored procedure as follow. This is just an example:


select field1, field2 from table1 where field1 = 1

I need to change this stored procedure so that if field2=0 then it will
be displayed on the web application as 'Yes', if field2=1 then I need
to display the text 'No' on the web application.
Field2's type is bit, ie: its' value is either 1 or 0.

Thanks for any suggestion.

Sincerely,
Teresa

[Back to original message]