Rich,
set filter to trim(this.value) $ fieldname
>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????
>
>Thanks to all...............Rich