Something like SELECT Decode(column_name,1,'Yes','No') AS column_name FROM table WHERE criteria
Will return 'Yes' when column_name is 1 and 'No' when column_name is anything else Matt Osbun Web Developer Health Systems, International -----Original Message----- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 31, 2005 11:33 AM To: CF-Talk Subject: RE: Oracle SQL alternative for YesNoFormat() ? > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Bobby, > > This doesn't work for me because the values in the database > are in a numeric column and stored as 1 or 0. I need the > query to return 'yes' or 'no'. The query results are used > for a CFINDEX, so the only option I can think of at this > point is to build a NEW query and transform those values as I > loop through the original query recordset. This will add > alot of overhead to the process though. > > I can't do a PL/SQL function either, so that's not an option. > > Anyone else have any other ideas? I am not familiar with Oracle but what about a CASE statement? When field is 1 then 'yes', etc... CONFIDENTIALITY NOTICE: The information contained in this transmission, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited by Federal law. If you are not the intended recipient of this message, you are notified that you may not disclose, print, copy, or disseminate this information. If you have received this transmission in error, please reply to the sender and delete or destroy the message. Unauthorized interception of this transmission may be a violation of criminal law. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217011 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
