How can I use the "AS" Operator in an SELECT-Statement

[SoftIl]

Hi Ivan,
thanks for your very fast answer.
But it dosen't work. :-(

I tried it in ViSQL:
SELECT record_id AS 'recIDBetrieb' FROM betriebe   --> retuns 0 records
SELECT record_id  FROM betriebe  --> returns 7 records

If I try it in Valentina Studio, I get the Kernel error 603 return.

Best regards,
Carsten

----- Original Message ----- 
From: "Ivan Smahin" <IvanSmahin at public.kherson.ua>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Thursday, June 02, 2005 11:54 PM
Subject: [Norton AntiSpam] Re: How can I use the "AS" Operator in an 
SELECT-Statement


> Hello SoftIl,
>
> Friday, June 3, 2005, 12:50:37 AM, you wrote:
>
> S> Hi,
> S> in MS SQL-Server  I can write this:
>
> S> SELECT dbColumnName AS TempName FROM myTableName
>
> S> and the column "dbColumnName" is in the resulttable renamed to 
> "TempName".
>
> S> How can I do this in an SELECT-Statement in Valentina?
>
>
> SELECT dbColumnName AS 'TempName' FROM myTableName
>
>
>
> -- 
> Best regards,
> Ivan                            mailto:IvanSmahin at public.kherson.ua
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>