Ok thanks, the sqltrace feature is handy, it was a display error as the trace looks to be perfect. Now its enabled the display shows the full query. Thanks for the help.