>Hi all. Now I’ve got a problem. I use Vfp6.0 (sp3) and Ms Sql(7.0). I try to write update statement. I wrote sql string in variable named SQL that is longer than 256 characters, I made separation on four sql strings (SQL1, SQL2, SQL3, SQL4) everyone is less than 256 characters. Than I concatenated my string in one SQL = SQL1 + SQL2 + SQL3 + SQL4 , but in debugger I saw that result string took only 256 characters all rest characters are cutting. Early I did that. What’s happened? Please, help.

Is this a string or a character field? Strings do not have a size limit...