<font face='Arial'>
Hello all,
I am trying to create one field out of two fields. To do so I would normally use:
<pre id=code><font face=courier size=2 id=code>
SELECT table.field1 & ' ' & table.field2 As NewField
FROM Table
</font id=code></pre id=code>
This worked just fine when I was using a DSN connection but as soon as I switched over to a OLE DB connection string I get a too few parameters error. I did a little troubleshooting and narrowed it down to having something to do with the ampersands. Any Ideas on how to get around this?
</font id='Arial'>

have you tried using plus signs instead of ampersands?