Smfc

  SQL Square Brackets [] 🔹 Introduction In Salesforce Marketing Cloud Engagement (SFMC), SQL is based on SQL Server (T-SQL) . Square brackets [] are used to escape identifiers such as: Column names Data Extension names This ensures SQL interprets them exactly as written.  Why [] Is Important SQL normally expects: No spaces No special characters No reserved keywords But in SFMC, real-world data often includes: Email Address Order-Amount Group 👉 Square brackets solve this by telling SQL: “Use this exact name.” 📌 Use Cases of [] 1️⃣ Column Names with Spaces SELECT [ First Name], [Email Address] FROM Contacts   Original DE Resultened DE  2️⃣ Reserved Keywords SELECT [ Date ], [ Group ] FROM Orders Original DE Final Result   3️⃣ Special Characters SELECT [ Order- Amount], [Discount % ] FROM SalesData   4️⃣ Data Extension Names SELECT * FROM [Customer Data 2025 ]   5️⃣ Aliasing SELECT ...

 % (LIKE Operator) – Use Cases 👉 % is used for partial matching / pattern search 👉 1. Find Gmail Users SELECT * FROM SFMC_Practice_DE WHERE EmailAddress LIKE '%@gmail.com' 📸 Query Execution 📸 Result (Filtered DE) 👉 2. Users whose name starts with "A" SELECT * FROM SFMC_Practice_DE WHERE FirstName LIKE 'A%' 📸 Query Execution 📸 Result (Filtered DE) 👉 3. Users whose name ends with "MEHTA" SELECT * FROM SFMC_Practice_DE WHERE LastName LIKE '%MEHTA' 📸 Query Execution   📸 Result (Filtered DE) 👉 4. Find users with "outlook" in email SELECT * FROM SFMC_Practice_DE WHERE EmailAddress LIKE '%outlook%' 📸 Query Execution 📸 Result (Filtered DE) 👉 5. Customers from cities containing "pur" SELECT * FROM SFMC_Practice_DE WHERE City LIKE '%pur% ' 📸 Query Execution 📸 Result (Filtered DE) 👉 6. Mobile numbers starting with 9 SELECT * FROM SFMC_Practice_DE WHERE MobileNumber LIKE '9...