Case sensitive filtering

depro

Hi,

I need to find value from text file in Customer Table.

My input string look like: 'COMPANY S.R.O'
In Customer Table i have cutomer like: 'Company S.R.O'

I`ve try to filter my customer table using this code:

Cust.SETFILTER(Cust.Name, '@' + COPYSTR(Name, 1, 30));

and this

Cust.SETFILTER(Cust.Name, '@%1', COPYSTR(Name, 1, 30));

but it isn`t work.

So i try to filter my Customer List using Field Filter and typing:
@COMPANY S.R.O. but this also don`t get me my record.

I am using NAV 4.0 SP3 with NAV 5.0 client, SQL Database.

Could anybody explain my why my filters doesnt work?

regards,
Depro

FDickschat

depro wrote:

Hi,

In Customer Table i have cutomer like: 'Company S.R.O'
...
So i try to filter my Customer List using Field Filter and typing:
@COMPANY S.R.O. but this also don`t get me my record.

To make it more clear:
Company S.R.O (Customer Table)
@COMPANY S.R.O. (Filter)

You have added one '.' too much at the end.

I filtered for exactly your string and it works like a charm (2009 SP1).