Continue SQL statement on a new line

[st3ve]

Its a long one!.... (because i've had to do a workaround to get this far), but anyway, how do i indicate line continuation? Any ideas

[This message has been edited by st3ve (edited 01-22-2002).]

 

[betsyr]

I think this is what you mean....

"SQL here..." & _
"more SQL here"

Hope this helps.

betsyr

 

[st3ve]

Cheers, i knew it was something simple. I'll try it when i get back to the office. Thankx again.