Can you copy and paste your actual select?

>No, that was a typo just when I wrote in the UT, error still exists.
>
>>You have wrong table name, 'thistable' instead of 'csulog6'.
>>
>>>In my VB asp page I have this line
>>>"SELECT distinct office FROM thistable where nsn like" + "'51%' order by office"
>>>
>>>and I get this error
>>>
>>>A field or property with the name 'nsn' was not found on the selected data source.
>>>However "SELECT distinct office,nsn FROM csulog6 where nsn like" + "'51%' order by office" does work
>>>
>>>PS, I am using VFPOLEDB to access a microsoft visual Foxpro table