Single quotes Escape from parameter values

Defined one parameter called "display_name" in sql editor and passing dynamic values in to it and capture in the where ( org_name in ('x','y','I'am there') ) clause as per below .however few values are already have single quotes in it (ex : I'am there) and throwing an error . any help? how to escape single quotes ?

select distinct ltrim(rtrim( as email from table_name a
and ltrim(rtrim(b.display_name)) in ({{display_name}})


{% form %}

    type: multiselect
    default: all
        labels: email
        values: email

{% endform %}

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 6 mths agoLast active
  • 49Views
  • 1 Following