SELECT CASE WHEN yourColumn = 1 THEN 'yes' ELSE 'no' END as yesNoFormat FROM yourtable
On 8/29/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I know this is a bit off topic, but I developing an app in CF accessing an > Oracle DB and I need my query to return the results in the format of 'yes' or > 'no' for 1 or 0 respectively. Anyone know how I can do this within the SQL > select statement? > > Thanks, > > Dave > ****************************************************************************************** > The information contained in this message, including attachments, may contain > privileged or confidential information that is intended to be delivered only > to the > person identified above. If you are not the intended recipient, or the person > responsible for delivering this message to the intended recipient, ALLTEL > requests > that you immediately notify the sender and asks that you do not read the > message or its > attachments, and that you delete them without copying or sending them to > anyone else. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
