re: Escaping characters in select query problem...

2002-09-10 Thread Egor Egorov
Mike, Monday, September 09, 2002, 2:45:36 AM, you wrote: M > I am having trouble with an sql query. I have a table with a column that M > has an '#' sign in the name. The problem is I can't seem to escape the M > column name to be able to select it. M > IE: M > select test#1 from test or sel

Escaping characters in select query problem...

2002-09-08 Thread Mike  
I am having trouble with an sql query. I have a table with a column that has an '#' sign in the name. The problem is I can't seem to escape the column name to be able to select it. IE: select test#1 from test or select `test#1` from test Both don't work and i get the error Unknown column 't