[sqlite] how do i declare and use variables in sqlite?

[Chase]

select 542 as x;
that part works, but then when i try to access it, i get "no column x"...

select x;

set x = 542;
var x = 542;
@set x = 542;
@var x = 542;
set @x = 542;
var @x = 542;
$set x = 542;
$var x = 542;
set $x = 542;
var $x = 542;


none of these seem to work and i can't find the documentation on this 
subject.

can someone shed some light on this for me?

thanks.

- chase



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------