it's strictly a cosmetic thing... if you were to print out the statment with the vbcrlf, then your sql would be "nicely" formatted on multiple lines... if you skip the vbrclf, then it gets appended as one big long line. Thing is SQL doesn't care if it's on one line or multiple lines... all it cares about is the syntax. as long as you leave a space on the end so that your words don't slam into each other, then you can skip the vbrclf. SQL won't care.

-tg