Milla,

Thanks so much again. Yes, the link helped and he found the same mistake as I did. 🙂

Good day!

When I copied Milla's code to a stored procedure, I needed to use a dynamic sql, then an error is raised: The identifier ... maximum is 128. I added a...

Milla, thanks for the beautiful code. I appreciate it. By joining the contact table to the first select statement I got what I want.

Bruce, I appreciate your help as well,...

Lynn,

What is the purpsoe of Cast for @colvalue. It is declared as an integer, now you changed to varchar.

Yes, it helps to solve the problem of conversion error above,...

GSquared,

Thanks much for your comprehensive advice. It is very helpful.

Ronald,

Your seggetion encountered with the same type of error saying...

Conversion failed when converting the nvarchar value 'SELECT * FROM Tasks WHERE colname=' to data type int

Any comments???

Thanks,

Lynn, Thanks for your advice.

I am not using any forms/reports. I just created a query in Access,and it gives an error described above. Basically my question would be the capability of Access to link...

I've nver heard about Apex SQl Diff, but will take a look.

Thanks,

That's it. Thanks.

For others who are looking for similar answers this article might be helpful: http://www.sqlservercentral.com/scripts/T-SQL/61312/ (how to empty database)

Thanks again for your reply.