after reading your sql string several times i realize something.. I don't know what are you trying to achieve!!!
please... if you are so kind, paste an example of the final sql and maybe we can help you better...
The problem I have is with the set clause.. you are trying to put that field equal to..????
and after you add the > you finish confusing me...
Read this if you want to know how to get a correct reply for your question:
^^Took that from dparsons signature and he Took that from planoie's profile