Pattern matching with Like (% ,_) in SQL

                                                                      


                                                             LIKE % :-


Source DE :-


Target DE :-



                   

        Query for Like text% :- 

Select Name,[Email address],Age From [New_customer_DE] Where [Email address] Like 'pawan%'



Target DE after query run :-



Query for Like %text :- 

Source DE


Target DE


Query:-


Query run complete


Target De after query run:- 



LIKE _ (underscore)




Source DE 






Target DE


Query run 
Select Name,Age,[Student ID],Gender,[Course name] From Enhance_dynamic_content Where [Student ID] Like '3__' 

Query run complete 


Target DE after query run 
























Comments

Post a Comment

Popular posts from this blog

Use Cases of Standard Data Extensions

Use Cases of Standard Data Extensions 1. Customer Data Storage Scenario : A retail business wants to store customer information, such as names, email addresses, and purchase history, for email marketing campaigns. Solution : Use a standard data extension to store and manage customer data securely and efficiently. Data Extension Structure Field Name Data Type Length Required Primary Key SubscriberKey Text 50 Yes Yes FirstName Text 50 Yes No LastName Text 50 Yes No EmailAddress EmailAddress N/A Yes No PurchaseHistory Decimal N/A No No Email - Marketing Cloud
Read more

Data retention policy

Image
📌 Task: Create & Monitor Data Extensions with Different Retention Policies 🚀 By ElearningIT Feb 18, 2025 Your objective is to: ✅ Create three separate Data Extensions (DEs). ✅ Apply a different retention policy on each DE. ✅ Monitor & analyze the impact over time. 🔹 Step 1: Create Three Data Extensions (DEs) 1️⃣ Navigate to: Email Studio > Subscribers > Data Extensions. 2️⃣ Click "Create" → Select Standard Data Extension. 3️⃣ Define the fields for all DEs using the structure below: Field Name Data Type Length Primary Key SubscriberKey Text 50 ✅ Yes Name Text 50 ❌ No Email EmailAddress 254 ❌ No Phone Phone 50 ❌ No SignupDate Date - ❌ No 4️⃣ Create three Data Extensions with unique names: DE_IndividualRetention (For Individual Record Retention) DE_AllRecordsRetention (For All Records Retention) DE_FullDeletion (For Data Extension & Records Retention) 5️⃣ Import at least 100 records in each DE (via CSV or manual entry). 🔹 Step 2: Apply Different Retention P...
Read more