>Hi Ivan
>Back in fp 2.6 days (before CM) I used a Find dialog box that would compare using UPPER for Character & Memo fields. Some time ago I comverted it to vfp. However, the CM Find Dialog box has some nice things & the user likes them, so I would have a hard time switching them at this point.
>I briefly looked at frmFindDialog in cmLookup.vcx and I'm not eager to modify that code. Where Dave does the actual lookup is not apparent to me.
>
>About 4 years ago Dave replied to my email about using UPPER in the Find Dialog as follows.
>"Yes you can add UPPER to the Find search by adding UPPER to the expression that the lookup is based on."
>I interpreted that as meaning you need to change the table index, which I did to UPPER(cName_ID).
>When I opened the Find Dialog the index that I had just changed was not there.
>
>Any idea what Dave meant? Also, I'm not sure that what he said still holds true with CM 7.5.
>All help appreciated.
>Bill
Oh, yeah, got it.
If you index your table on UPPER(YourFieldName), then you can enter upper or lowercase in the Find Dialog, and it will convert to UPPER for this tag.
Then, go to your form's cmLookUpManager, and put this code in its GenTagList:
THIS.DefineTag('YourTagName')
THIS.SetTag('YourTagName', 'DisplayName', 'Your Nice Name')
Then, test the Find Dialog again.
Ivan