# SETFILTER case - insensitive **URL:** \ **Category:** Developers Forum\ **Created:** [January 5, 2002, 5:20pm UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618 "2002-01-05T17:20:37Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [January 5, 2002, 5:20pm UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/1 "2002-01-05T17:20:37Z")
Hi, Is it possible to filter a table case - insensitive for a given (entered by user) search name (text type)? ---
**Author:** ![John\_Tegelaar](https://avatars.discourse-cdn.com/v4/letter/j/f07891/32.png) [@John\_Tegelaar](https://www.dynamicsuser.net/u/John_Tegelaar)\ **Post date:** [January 5, 2002, 10:47pm UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/2 "2002-01-05T22:47:15Z")
Yes, you can. Put an “@” in front of the filter text to make the search cas-insensitive. John ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [January 6, 2002, 11:53am UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/3 "2002-01-06T11:53:45Z")
Thank you, John. It works great! I made some silly solution by checking: lowercase(searchName) or uppercase(searchName) or sentenceCase(searchName). But it does not cover every case-insensitive situation. Thanks again. ---
**Author:** ![Jens\_Rainer](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@Jens\_Rainer](https://www.dynamicsuser.net/u/Jens_Rainer)\ **Post date:** [January 6, 2002, 12:26pm UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/4 "2002-01-06T12:26:19Z")
When performing a case-insensitive search on a case sensitive column, you are likely to experience performance problems as the database server might have to scan quite a large number of records to find the record(-s) matching your filter. If you intend to perform a lot of searches like that, particularly in large tables, you might want to create a “Search Name” column of type Code, index the column, and then search for the up-cased string in that column without using the @-operator. - Jens ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [January 6, 2002, 12:38pm UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/5 "2002-01-06T12:38:40Z")
Thank you again, John, Actually, I was filtering (not searching) a table of items by their description, where the first few letters will be written by the user. After pressing Enter, the table will appear, showing only items beggining with “Ser”, for example. So, there should be no performance problems. Thank you. ---
**Author:** ![robertc](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@robertc](https://www.dynamicsuser.net/u/robertc)\ **Post date:** [January 7, 2002, 8:48am UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/6 "2002-01-07T08:48:24Z")
The @ operator also introduces accent-insensitivity, not just case-insensitivity. So all characters that are grouped by equal accents will be considered equal and match in the filter. Doesn’t matter if you only store ASCII range characters. In Navision Server this is determined by the chartable entry in the (server) stx file; in SQL Server it is determined by the collation. ---
**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\ **Post date:** [January 8, 2002, 9:26am UTC](https://www.dynamicsuser.net/t/setfilter-case-insensitive/5618/7 "2002-01-08T09:26:00Z")
Thank you all, John, Jens and Robert. You are very kind. 😉