• Jaideep Barud
  • NEWBIE
  • 0 Points
  • Member since 2016
  • Developer
  • Tata Consultancy Services Ltd.

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Hi, I was attempting to demonstrate the case-insensitivity of 18 char ID to my peers and I can't seem to get it to work. 

 

I ran this soql query:

select id from account where ID = '0013000000Hk05sAAB'

 

 

which successfully reports 1 record. 

 

When I try the all lowercase version 

 

select id from account where id = '0013000000hk05saab'

 

 

It reports 0 records. 

 

Is this a bug? A limitation of SOQL? Did I misunderstand the case-insensitive nature of 18 char id? I'm confused why the 2nd one pulls up 0 records.