Decode(myField, 1, 'Yes', 'No') asuming myField is in the set {1,0}
DK
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.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216692
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
