Hi. I am using Stonefield Query for my find screen. When I press the find button, Stonefield Filter screen is invoked. (Good!). I have an unusual circumstance on my Customer and Vendor numbers. My field can contain either numbers or alpha characters - but not both.

The index I usually use on this field is:
IIF(VAL(custno)=0,custno,PADL(STR(VAL(custno),10),10))

When I enter a Filter like: Customer (field name from lookup) EQUALS '10', I get no records. I must enter it like ' 10' in order to get a match. This is too hard to remember for the clients, so I want to put some custom code in the field screen to change the search expression with respect to custno or vendno (field names) to the above mentioned expression. Where do I put this code?

TIA

Sandi Cassidy