You can use string continuation like below Set(SelectStatement, " & Select col1 ... & From Tab1 & Where Col1 = Col2 ") If the statement is really long it is better to put it somewhere else. Perhaps a separate database job run dynamically like JobRun "my db job..." or alternatively JobDescribe("my db job ...", "SQL", SelectStatement) In a database job you can use SQL Editor to enter and maintain the SQL while in JAL and in VB you have to code it as a string. : Hi, : How can I set a really long string to a variable without : using concatination. I am trying to assign a really long : select statement and want it to be idented properly : with new lines. : For example: Set SelectStatement "Select col1 : From Tab1 : Where Col1 = Col2 "
|