Fred,

When trying to debug SPT it's beneficial to look at the actual SQL string before you send it off to the server ala debugout lcSQL

>Well that certainly works - thanks, but I still do not understand why the original code did not work.