Queries are not case sensitive

[HUANGCONG]

When I query the table, I can not be case-sensitive, how to solve it

[Yashsvi]

Hi @HUANGCONG,

please check below link:

https://www.servicenow.com/community/developer-forum/case-insensitive-glide-record-query/m-p/1461008

Thank you, please make helpful if you accept the solution.

[Mark Roethof]

Hi there,

Can you be more specific? How do you query the table? Something manual? Something scripted? Something else? Can you also give an example?

[OlaN]

Hi,

That's correct. GlideRecord query is not case sensitive.

You will have to do some workaround to get records that match on case formatting.

One option would be to use the GlideFilter API

Or just loop through all records that match and do a simple string comparison on each record to see if the case matches also.