You should be able to escape the column with another #. See:
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+POUND+or+DOLLAR+symbols+in+my+queries%3F
On 8/11/05, Henry Lu <[EMAIL PROTECTED]> wrote:
How do I use a SQL statemen including a column name with #:
EXample:
select emp#, empName from emp;
-Henry
