>We have a table with a PONUM field. The field is 15 characters and when the PONUM is assigned it is padded with leading zeros.
>
>I've got a textbox which is used to set a filter on the cursor with this field. In the InteractiveChange event I need to put the equivalent of
>
>SET FILTER TO MyStripLeadingZeros(fieldname) = TRIM(this.value)
>
>This would mean that, if you type a "1" all the following records would be included in the filter
>
>000000000000001
>000000000000011
>000000000000112
>000000000010012
>000000001122334
>
>If you then added a second "1" ("11") it would reduce the selected list to
>
>000000000000011
>000000000000112
>000000001122334
>
>I'm not happy with my version of MyStripLeadingZeros()
>
>Can somebody give me a reasonable efficient implementation of it????

Why not use LTRIM():

SET FILTER TO LTRIM(fieldname,1,"0") = TRIM(this.value)