Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Modifying case sensiti...

Modifying case sensitivity of 'type to filter' search box

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

When we open a page (lets say Chart Of Accounts) client side and use a wildcard like A*S in the filter search-box, we get everything that starts with A, ends with S and is written in capital letters.

I would like to get the same results like the above if i typed a*s or A*s.

I am aware of the @ operator leading to case-insensitive search but i would like to implement it in the back-end so the user is not required to use the operator.

Is this possible?

Thank you.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (1)

Report

RE: Modifying case sensitivity of 'type to filter' search box

I don't think you can do that in coding.

One way of doing it is alter the database collation to not case-sensitive. This will be system wide change though.