>If my customer has typed phone number with and without the "-"
>as below
>
>221-4997
>222-3991
>222 3944
>223-6675
>222 3671
>
>How can I filter all 222-3, by I ignoring the "-"
>as all the numbers of the table had not the "-"
>using set filter

lcPhone = alltrim(strtran(thisform.txtPhone.value, "-","")) + '%'

select * from myTable where phone like m.lcPhone into cursor curResults nofilter

select gridCursor
zap
insert into gridCursor select * from curResults

Also check Format in Help. You can set format and inputmask of the textbox to use -, but the value would not have -.