>My select statement works great if the string length <= 255 characters but I get a syntax error if it gets any bigger. I have searched past threads and found that this problem/bug exist. Does anyone know of a work around or if VFP 6.0 overcomes the problem? I am using VFP 5.0a now.

I believe that this limitation is only true when entering the SQL in the properties sheet. Try Building the string in code and assigning the rowsource programmatically.

If this doesn't work, create a method called something like populatelb and exewcute your query in there. In that method, you can scan through the results and use Additem. You would then call this method instead of listbox.requery().