Re: Select As question

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sun, 21 Mar 2010 19:12:25 +0100
Message-ID: <80n5saF596U2_at_mid.individual.net>

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

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Received on Sun Mar 21 2010 - 13:12:25 CDT