I am trying to search a table where the design number is equal to the value that I enter. The following code demonstrates this:

SET EXCLUSIVE OFF
SET DELETED ON
USE ("U:\Data\Modacad.dbf")

lcdesign = 'modacad.key3'+'$'+'thisform.pageframe1.page1.text1.value'

WITH thisform.pageframe1.page1.list1
 .RowSourcetype = 3
 .Rowsource = 'SELECT mainkey FROM modacad where &lcdesign'+;
              ' into cursor result'
ENDWITH

The problem I have is when I enter a design number for example JKT400 the results in my list box shows just:

JKT400

What I would expect to see is:

JKT400
JKT400B
JKT400C
JKT400NH

I thought the = condition meant beginning with and the == was exact match. Can anybody help me in determining how to change my search criteria so that I can get the results shown above.

Many Thanks in Advance