Hi ,
I need to do the following:
Given a certain variable for example @var I want to include the
contents of that variable as part of the name of a result column.
I'll try to explain myself a bit more with this example
Set @var = 'October_' ;
Select
Tot as 'Totals' <-- Here I would like to include the
contents
of @var
From sales So the resulting column name would be
'October_Totals'
The reason for this is because I don't know the value of @var which is
typed by the operator at the time the query is run.
Is there a way to concatenate the contens of a variable and a column
alias at run time ?
thanks for your ideas
Mauricio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
