Title: Shortcode SQL="&"
Last modified: August 22, 2016

---

# Shortcode SQL="&"

 *  [roger.borghol](https://wordpress.org/support/users/rogerborghol/)
 * (@rogerborghol)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/shortcode-sql/)
 * Dear Sir,
    I m facing a problem while using the abase shortcode sql.
 * If I includes ‘&’ character inside the shortcode, it will not work.
 * Example:
    [abase sql=”select name, team,msc,technology,rate from v_emp_skills
   where LOB=’C&TIS’ and rate <> ‘N/A’ order by rate desc”]
 * As you can see the LOB condition value ‘C&TIS’, it includes ‘&’ Character, so
   it doesn’t bring any records.
 * Please advice.
 * [https://wordpress.org/plugins/abase/](https://wordpress.org/plugins/abase/)

The topic ‘Shortcode SQL="&"’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/abase.svg)
 * [ABASE](https://wordpress.org/plugins/abase/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/abase/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/abase/)
 * [Active Topics](https://wordpress.org/support/plugin/abase/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/abase/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/abase/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [roger.borghol](https://wordpress.org/support/users/rogerborghol/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/shortcode-sql/)
 * Status: not resolved