Change the operator from ">=" to "="

>Jayesh,
>
>Thanks for the help, but for some reason I tried what you had suggested and I still got an unexpected lookup result. If I enter "LE" in my textbox that's tied to ALLT(m.stext) then the result listbox always starts with names beginning with "LA" not "LE". I thought your code would work great. I wonder why it doesn't work. It works just like my commented out code below. Any ideas? Thanks again.
>
>I tried SET EXACT ON and that did nothing new.
>
>Here's my latest code for doing a lookup of a record.
>

>SELECT agency
>SET FILTER TO
>IF THISFORM.Stype.Value = 1 && Search on Agency Name
>	SET ORDER TO agcy_name
>	lnSearchLen=LEN(ALLT(m.stext))
>	SET FILTER TO LEFT(agency.agcy_name,lnSearchLen)=>ALLT(m.stext)
>*	SET FILTER TO agency.agcy_name => ALLT(m.stext)
>ENDIF
>IF THISFORM.Stype.Value = 2 && Search on Agency ID
>	SET ORDER TO agency
>	lnSearchLen=LEN(ALLT(m.stext))
>	SET FILTER TO LEFT(agency.agency,lnSearchLen)=>ALLT(m.stext)
>*	SET FILTER TO agency.agency => ALLT(m.stext)
>ENDIF
>