Re: Select As question

From: Tony Sequeira <nobody_at_127.0.0.1>
Date: Sun, 21 Mar 2010 17:46:31 +0000
Message-ID: <4ba65b75$0$2474$db0fefd9_at_news.zen.co.uk>



GhostBuck wrote:
> In SQL I am able to select a field as something else. I will use this
> in generic function for naming grid columns readable to the user.
>
> e.g. Select bdate as [Date of Birth] from ....
>
> Oracle via ADO does not seem to like the [] around the "AS" name. How
> would I accomplish this in Oracle?

Try with double quotes, so:

Select bdate as "[Date of Birth]" from ....

May help. Know nothing about ADO, pardon if this has been tried and discarded.

-- 
S. Anthony Sequeira
++
As usual, this being a 1.3.x release, I haven't even compiled this
kernel yet.  So if it works, you should be doubly impressed.
(Linus Torvalds, announcing kernel 1.3.3 on the linux-kernel mailing list.)
++
Received on Sun Mar 21 2010 - 12:46:31 CDT

Original text of this message