I was curious if anyone knows how you describe the following SQL functionality:
SELECT 'mike' as name returns a single column named "name" with a single row containing "mike" I also know you can do stuff like: SELECT 1 Which returns a column named "1" with a single row containing "1", or: SELECT 4/2 which returns a column named "4/2" with a single row containing "2.000" The last one is obvious as it's SQL arithmetic, but what are the first two examples? Are those also examples of "SQL arithmetic" as well? I can't find this kind of SQL functionality described or documented anywhere on the net. Thanks! Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4