Assign a variable a very long 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 "

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 "

Is there an upper limit on string variable length...?
I got syntax error after adding certain length of text
using string continuation. There is nothing wrong with use of quotes or & sign.

: 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.