>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.