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

[Ivan Smahin]

Hello SoftIl,

Friday, June 3, 2005, 9:00:28 AM, you wrote:

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

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

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

Very strange. I just tried it self and got correct result.
Anycase I don't see any relation between "AS" and record count in the result.
Would you be so kind to send me "create table" script or database or something else
for reproducing this problem?


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua