Thanks y'all. I think this will work. Dave
-----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 3:31 PM To: CF-Talk Subject: Re: SOT: Oracle SQL alternative for YesNoFormat() ? 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:217005 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
