I think I have seen this before... Does anyone know if it is possible to get SQL (MS SQL 7 server) to dynamically change the value of a column?
I need to change binary values 1/0 to T/F in a SQL statement. I am looking for something like: Select Fname, lname, IF (member){ "T" else "F"} >From members Thanks much Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists