1

Are Data Extension values case sensitive when querying with SQL query activity?

I found this to be the case when querying WHERE Status = 'Active' that it ignored records with a status value of "ACTIVE".

I suppose I could use WHERE Status LIKE LOWER ('Active'), but I had no idea that querying the data extension values were case sensitive. Anyone else come across this?

2

No, the SQL Server back-end is not case-sensitive.

Per the official docs:

SQL support for the SQL Query Activity is based on SQL Server 2005 capabilities.

(I believe the infrastructure is now newer than SQL Server 2005)

Also in the Filter documentation about operators:

Search strings are not case-sensitive.

Also per Michael Clark at SF, subscriber keys are case-insensitive.

Additionally, as far as I know, these are the only places in SFMC that are case-sensitive:

  • File naming patterns used in Data Extract and File Transfer Activities in Automation Studio
  • Server-Side JavaScript code
  • 1
    Do you happen to have a link to a doc or something? I don't doubt your answer, but given the original question, I think having some documentation that backs your answer would be helpful. – sfdcfox Apr 17 at 4:00
  • Duh, of course. It'd be nice if it was specifically called out on in the query documentation -- other than the server version. Perhaps someone who knows officially can weigh in. – Adam Spriggs Apr 17 at 11:49
  • 1
    Thanks @AdamSpriggs. I could've sworn it excluded all caps values but when I went to replicate it, I wasn't able to replicate. Thanks for confirming! – Jackson Chen Apr 17 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.