On Thu, 20 Apr 2006 16:21:29 -0700, Loo, Peter # PHX wrote: Hi Peter
> Yes, thanks. I have it working now. Now I am working on the > UPDATE from a SELECT. I am having problem with char columns. I am > working on a routine that will identify the columns that require > quotes and dynamically plug them in before doing the update. You're wasting you time, and unless you're infallible, will probably write code which fails one day. Use placeholders, as I said in my other post a moment ago. -- Cheers Ron Savage, [EMAIL PROTECTED] on 21/04/2006 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company