Hello,

I am trying to build a SQL statement dynamically for execution within a
procedure, using PREPARE ... OPEN.

SET v_sql = ' SELECT a,b,c,d,e, .....x,y,z FROM  table1, table2  WHERE
a = v_1...and so on   FOR READ ONLY';

What is used for continuation if I want to break the variable v_sql out
into lines so one can read it?

SET v_sql = ' SELECT a,b,c,d,e, .....x,y,z   (what goes here?)
                   FROM  table1, table2             (and here?)
                   WHERE a = v_1...and so on   (and here?)
                   FOR READ ONLY';

Thanks