Introducing SQL for CRM Analytics
Quick Start: Run Your First Query
SQL vs SAQL
ascii(char)
chr(int)
char_length(str)
ends_with(source_str, search_str)
index_of(source_str, search_str, [position,occurrence])
lower(str)
mv_to_string(multivalue_column_name, [delimeter])
position(search_str IN source_str)
replace(str, old_str, new_str)
starts_with(source_str, search_str)
substring(str FROM start FOR length)
trim(LEADING | TRAILING | BOTH, chars, str)
upper(str)
Release Notes
Previous Versions