Re: Select As question

From: Robert Klemme <>
Date: Sun, 21 Mar 2010 19:12:25 +0100
Message-ID: <>

On 03/21/2010 06:46 PM, Tony Sequeira wrote:
> 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.

I believe double quotes are quite standard in SQL land. So my first choice would be

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

Kind regards


remember.guy do |as, often| as.you_can - without end
Received on Sun Mar 21 2010 - 13:12:25 CDT

Original text of this message