How to SETRANGE or Filter with NO Case Sensitive

selece28

Hi Nav masters,
I have a problems when filtering with SETRANGE, i filter a text variable.
Ex: i have "Andy" on my table, but when i filter using "andy", the SETRANGE cant find it. I know this is because SETRANGE is Case Sensitive
Is there any way NAV can filter without Case Sensitive ?

Thanks

Waldo

Yes, don't use SETRANGE, but SETFILTER.

recYourTable.SETFILTER("Your Field", '@%1', 'andy');
should do the trick... . The '@' makes your filter case unsensitive.

:-k