Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

WOW! SQL queries are case insensitive

Salesforce Marketing Cloud Tips

I recently discovered that when querying data views, case sensitivity in column names doesn’t make a difference; it consistently picks up the column when named correctly. Let’s explore where else column case sensitivity doesn’t play a significant role.

First let’s create a data extension with some columns so we can test following in Query studio, Automation Studio and in AMPScript.

We will attempt to execute the following query. As you can observe, I’ve referenced “FirstName” differently in the WHERE clause.

Select fIrStnAme,LaStName from mArCel_TeSts where FiRstnAmE = 'Marcel'

Query studio

Column and even table names can be in random case, and the system still accurately retrieves the correct data.

Automation Studio

I was initially skeptical about running the same query in the automation studio. However, when the query was successfully validated, I had no doubt that this case insensitivity is indeed functioning as expected.

Once we had provided the WHERE clause and all the required columns, the automation worked seamlessly and efficiently moved the data to another data extension.

AMPScript and SSJS

I had the most doubts about AMPScript and SSHS, but to my surprise, it works just as well as in other cases

SET @name = LOOKUP("marcel_tests","EmAiLADdresS","EmaIlAddResS","")
<script runat="server">
     var name2 = Platform.Function.Lookup("maRcel_Tests","EmAiLAddreSs","EMaIlADDreSS","");

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

#AMPScript #JavaScript #SQL
Marcel Szimonisz
Marcel Szimonisz
MarTech consultant As a marketing automation consultant, I specialize in solving problems, automating processes, and driving innovation in my clients' marketing platforms.

I hold certifications in Adobe Campaign v6 (3x certified) and Salesforce Marketing Cloud (5x certified).

Additionally, I serve as a community advisor for Adobe Campaign, offering expert insights and guidance.

In addition to my professional pursuits, I also enjoy exploring various programming languages, CMSs, and frameworks, further enhancing my technical expertise and staying at the forefront of industry advancements.
Take a look at our subscription offering in case you are looking for a Marketing Automation Consultant.

Leave a comment

Your email address will not be published. Required fields are marked *

Similar posts that you may find useful

Queries in SSJS and AMPScript
Marketing Automation, Salesforce Marketing Cloud

Query data extensions with SSJS and AMPScript

1 minute read

There’s another topic for which official documentation often lacks sufficient information, but it can be incredibly useful when needed. It’s important to note that in AMPScript, we use the data extension name to reference the table for any query. On the other hand, in SSJS, we utilize the data extension’s external key to reference the […]

Continue reading
Email marketing terminology
Marketing Automation

Email marketing (automation) basics

4 minutes read

Email marketing automation has become a crucial aspect of every campaign manager’s day-to-day work. Whether you’re using any email marketing automation platform, understanding the fundamentals is essential. This guide covers the basics that are shared across all platforms, ensuring you have a solid foundation in email marketing automation. Multichannel interaction Reach your recipients through various […]

Continue reading
ACC - How to JavaScript in Adobe Campaign Classic
Adobe Campaign, Marketing Automation

Master JavaScript in Adobe Campaign

7 minutes read

Adobe Campaign Classic utilizes JavaScript as the backend language for customizing various aspects of your instance, including workflows, libraries, web applications, and reports. The platform employs the Java Web Server called Tomcat for its operation. To execute JavaScript on the server, Adobe Campaign Classic utilizes a JavaScript engine called SpiderMonkey. SpiderMonkey, developed by the Mozilla […]

Continue reading
Adobe Campaign post
Adobe Campaign, Marketing Automation

Complete guide to data schemas in ACC

4 minutes read

I want to gather as much information I have and have it at one place for my future reference and for others to learn what can be possible with the custom schemas in the Adobe Campaign Classic – ACC If you work with adobe campaign for some time you might figured out that almost any […]

Continue reading
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Proof email was previewed but not received

2 minutes read

There are many possible issues, and I will try to list all those I have come across during my times when I wondered where my email is. Contact is unsubscribed If the contact you are trying to preview an email with is on one of the global unsubscribe lists, or has unsubscribed or bounced status […]

Continue reading