Thanks for the info.
What if I want the alias to contain a space character in it ?
- Danny
----- Original Message -----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: <radiusnt@iea-software.com>
Sent: Wednesday, August 18, 1999 12:22 PM
Subject: Re: [RadiusNT] SQLServer Column Aliasing
> Danny Sinang wrote:
> >
> > Does anyone here know how I can do Column Aliasing in SQL Server ?
> >
> > I am presently trying to shift to SQL Server from MS Access97.and my ASP
> > scripts won't run anymore.
> >
> > It seems SQL Server does not recognize column aliasing like MS Access
does.
> > For example,
> >
> > Select column1 as [Column 1]
> > From mytable;
> >
> > is erroneous according to SQL Server.
>
> Try this:
>
> Select AccountID as a
> From SubAccounts
>
> or
>
> Select a=AccountID
> From SubAccounts
>
>
> Loose the [] and the ending ; as well.
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart