semi OT : SQL syntax question

[Trevor DeVore]

On Jun 29, 2005, at 5:05 AM, jbv wrote:
>
>     put "SELECT "$"+toString(id)+"$", col_1, col_2 FROM myTable  
> WHERE id
> < 100" into myREQUEST

This works in MySQL:

SELECT concat("$",ID,"$") as myCol, col_1, col_2 FROM myTable WHERE  
id < 100

-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com