Format in a one line

rreis

SQL Prompt is one of the useful tools that I worked with. However when I want to copy a SELECT statement to an ASP file it is necessary to put all in one single line. Is there a way to do it?

Thanks,
Rui Reis

Anu D

Thanks for your post.

I doubt you can do this at the moment.

Workaround is that you can type the valid/required query without using enter key so that query will remain on the single line and than before using LAYOUT functionality of SQL Prompt copy paste the query in your ASP code.

Hope the suggestion doesn't sound stupid :!: