It worked like a charm and gave me exactly what I wanted.

Thank you very much.

I'm new to this forum and will use the IFCode shortcuts in the future...

I thought I was using dynamic sql. The same construct worked for defining the columns in an ALTER statement but does not seem to work in the UPDATE statement. I...

Thank you very much. Mycolums were created named exactly how I wanted them. However, I now have a problem accessing the columns using variables. I need to update the values...