Hi Ryiaz,

It's VFP limit for lenght command row...

lcSQL="SELECT ....."+;
      " FROM ...."+;
      " ORDER BY ..."

=SQLEXEC(1,lcSQL)

MartinJ

>Hi All
>One of my SqlExec statement has gone beyond 255 Characters and when it is compiled it gives error "unrecognised Command/Keyowrd"
>
>Is there a way i can solve this problem
>
>Thanks in Advance.