>Hi,
>
>I have come across an issue where when I try to macro expand a string (that contains INSERT command) and the string is over 612 characters I get error. If the string is less than 612, macro works.
>
>Is there a limit? And if there is, if there a way to get around it?
>
As Naomi said, makro length is sligthly above 8K, so only very elaborate SQL statements are endangered (when code is generated, wheretype key and modified creates longest lines).

You are perhaps running against line length: see Hilmar's code easily breaching a couple of K.

HTH

thomas