I am trying to experiment on this code below. However, I could not get it to find a similar value. For instance, if I type in 1101, I don't get anything. Please help.

lcPartNum = UPPER(ALLTRIM(THISFORM.txtPartNum.Value))
SELECT * FROM customer x WHERE x.partnum LIKE '&m.lcPartNum%'

Thanks,
Sam