>Naomi,
>
>Actually there is more to that query. It is a part of a stored procedure called from an ASP.NET application. Based on the parameter passed I am dynamically building the actual query.
>
>I could not come up with a way of doing this without using Execute.
>
>Thanks again for your help,
>DAniel

BTW, it's really funny that the same questions repeat on the same day Sql statement with multiple single quotations Thread #1217632 <g>