semi OT : SQL syntax question

[jbv]

Hi list,

I'm trying to write a specific SQL request but get only exec errors...

here's the basic request :

    put "SELECT id, col_1, col_2 FROM myTable WHERE id < 100" into
myREQUEST

but in the results, I would like each id value to appear like "$12$"
therefore I tried :

    put "SELECT "$"+toString(id)+"$", col_1, col_2 FROM myTable WHERE id
< 100" into myREQUEST

but it doesn't work, while the following works :

    put "SELECT 1+id, col_1, col_2 FROM myTable WHERE id < 100" into
myREQUEST

but it only adds 1 to each id value...

id is a primary key, positive integer, auto-increment.


Thanks for any help,
JB