Re: Spaces in alias

Posted in 1998

David Williams — Thu, 26 Feb 1998 07:34:24 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <6d1pk1$kpn$1@nnrp1.dejanews.com>, bes@hnc.com writes >Is there any way to put spaces in an alis in a select statement? > >In Informix you can do this: > >SELCT ITEM_ID AS "Item ID" FROM TABLE1.... > >Is there an Informix equivalent? > Why do you need to? Almost all computer languages do not support spaces in identifiers. Try select ITEM_ID "Item ID" FROM TABLE1... (Might not work). >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care