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