>>my WHERE CLAUSE says.
>>
>>in_fld = 'modem' && to test
>>
>>in_fld = alltrim(thisform.in_fld.value) && needs to be this..
>>
>>WHERE in_fld $ table_fld && this works until I take
>>say:
>>
>>WHERE upper(alltrim(thisform.in_fld.value)) $ table_fld
>>I have done everything..
>>
>>can somebody help?
>I'm not sure exactly what your quesion is, however, you need to strongly reconsider using the "$" as search criteria in your select statement. "$" is not optimizable, so the query is going to actually check each and every record for a match everytime you run your query. If your file is of any size, it is going to take a long time.

Hi Larry.. what should I use instead of "$"?