Glad you sorted it.

I take it that you just put the statement on multiple lines.

Best Regards

Mace

>I figured out where I was going wrong, you see there is a 2499 character per line limit and when looking up limits for SQL*Plus I got confused and reported 2499 lines, sorry. Your last message made me wonder and put things in right perspective.
>
>Thanks for your help
>Kapil.