This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
👋 Hey everyone! Ever encountered messy data causing SQL query headaches in Salesforce Marketing Cloud (SFMC)? Say hello to RTRIM(LTRIM())! 🌟 💡 Exploring RTRIM(LTRIM()) in SQL Explanation: RTRIM: ...
Critical Thinker | Business Intelligence Analyst | Guest Arrival Expert | Combining Technical Skills - Excel, SQL, Power BI - DAX, Visual Calculations, Reporting - with Business Insights from ...
SELECT @Fixed = CASE WHEN Ltrim(Rtrim(@Full)) LIKE '%~%' THEN substring(Ltrim(Rtrim(@Full)) , charindex('~' , Ltrim(Rtrim(@Full))) + 1 , LEN(Ltrim(Rtrim(@Full ...
一部の結果でアクセス不可の可能性があるため、非表示になっています。
アクセス不可の結果を表示する