>Hi Mark:
> It works with your syntax in the command window. However, I used extact command in my program it return empty cursor. Do you know why? THANKS
>SHERRY

Did you set a value for the variable?

local lcID
lcID = alltrim(upper(ThisForm.txtClientID.Value))
lcSQL = "Select clClientID from CLIENTTYPE where clClientID = '" + lcID + "'"