>>So the "$" operator should not be used in SQL? Also, then, it would appear that I have to take the text the user enters for SearchText and add the percent signs to the beginning and end of it before using that variable in the SQL statement?
>
>Correct.
>
>lcSearchText = '%' + alltrim(ThisForm.txtString.Value) + '%'
>
>Also use upper() if necessary.
Thanks Michael, Mark and Ed!
Phil Thomas
http://phillipdthomas.comNever let your energy or enthusiasm be dampened by the discouragements that must inevitably come.....