I'd rather reccommend

select * from stock_file where cstockid == padr(stock_id,len(cstockid)) into cursor cstock

>Just a side note. Why do you use alltrim? It gives zero benefit, and your query won't be optimized. Instead use
>

>select * from stock_file where cstockid == stock_id into cursor cstock

>>I want the user to pick the stock id:
>>
>>

>>stock_id = inputbox('Stock ID','Input Stock ID', space(20))
>>select * from stock_file where alltrim(cstockid)=alltrim(stock_id) into cursor cstock
>>
>>select cstock
>>browse normal
>>
>>?cstock.cstockid
>>

>>
>>how to make it looks better in the program?
>>which controls can I use to replace browse normal?
>>
>>thanks for the advice
>>
>>Jerry