Select to view content in your preferred language

Query tool 'contains' case sensitive? :(

2147
2
06-04-2012 04:09 AM
RobDunfey
Regular Contributor
Hello!

It appears the query tool, if you build a query with 'contains' against a string field, its a case sensitive query?  Is this correct or have I missed something?  Would be great to have the ability to control this.

Kind Regards,

Roberto
0 Kudos
2 Replies
DanPatterson_Retired
MVP Emeritus
is there an "upper" or "lower" option within the query builder (haven't used explorer online)?  If so, cast your query to either upper or lower prior to using the contains option ... common practice in many sql style queries
0 Kudos
JackZHANG
Frequent Contributor
Anyone has got an answer yet? go to https://c.na9.visual.force.com/apex/ideaView?id=08730000000boLA&mc=0 and vote the idea please
0 Kudos