In delphi, in the code source, sometime you need to write quite long string that is hard to keep on a single row like
'SELECT Email FROM Employee where NOT REGEXP_LIKE(Email, ‘[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}’, ‘i’);'
but in the code source to make it more readable you must split it in several rows like
'SELECT '+
'Email '+
'FROM '+
'Employee '+
'where '
'NOT REGEXP_LIKE(Email, ‘[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}’, ‘i’);'
but doing this (as far as i understand) will involve concatenation of string at run time and the compiler will also create internally several temp string to handle theses concatenations
So how efficiently in the code source split a long string on several row under delphi without affecting the performance ?