How to escape special characters (specifically '#')

[Narasimha Prasad]

Hi   Is there a way to escape the ‘#’ characters used in iBATIS SQL maps ? The reason is ask this is that we are running into a situation where we need to create Temporary tables to read from, and they use the # character.  I tried enclosing the statement with <![CDATA[ …. ]]>, but this works only to escape special XML characters.     Example: ---------------------------------------------------------------------------------- BEGIN   CREATE TABLE #tempCount (id INT NOT NULL, count INT)     INSERT INTO #tempCount   (id, count)   VALUES   (1,2)   SELECT * FROM #tempCount   DROP TABLE #tempCount END     Any suggestions welcome.   Thanks, Prasad     -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 3/9/2005