Re: [RadiusNT] SQLServer Column Aliasing

Dale E. Reed Jr. ( (no email) )
Tue, 17 Aug 1999 21:22:30 -0700

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