Setfilter

sabzam

Hi Everybody,

I need to create a setfilter which looks in a text field but which doesn't take in cosndieration whether the fields are exactly similar. FOr example:
TEXT and text should be regarded as the same. (Practically equivalent to the @ function when manually filtering)

kine

Native or SQL server?

sabzam

Sql Server

kine

Can you post the Collation settings of the DB? (File-Database-ALter-Sorting) - is it Case sensitive or insensitive?

sabzam

It is case sensitive. I just want to learn how to produce non-case sensitive setfilters

kine

  SETFILTER(MyField,'@'+MyFilter);
or
  SETFILTER(MyField,'@%1',MyValue);