Title: Does sorting must be case-sensitive ?
Last modified: September 1, 2016

---

# Does sorting must be case-sensitive ?

 *  Resolved [Theo](https://wordpress.org/support/users/dubeux/)
 * (@dubeux)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/does-sorting-must-be-case-sensitive/)
 * Hello,
    I’m trying to sort my `cfdb-table` using `SortByField`, but it’s case-
   sensitive. Any way no make it case-insensitive?
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/does-sorting-must-be-case-sensitive/#post-7620715)
 * It doesn’t have an option directly. But you could try making a temporary field
   will everything uppercase then sort by that.
 * If you are sorting by field “last_name”, create last_name_uc field and sort by
   that.
 * `[cfdb-table form="myform" trans="last_name_uc=strtoupper(last_name)&& SortByField(
   last_name_uc)"]`
 *  Thread Starter [Theo](https://wordpress.org/support/users/dubeux/)
 * (@dubeux)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/does-sorting-must-be-case-sensitive/#post-7620734)
 * Mr. Simpson, thank you very much for your usual amazingly fast and kind support.
   
   It did work perfectly. Let me just point out that I tried something similar, 
   after reading the [filter docs](http://cfdbplugin.com/?page_id=1073), but it 
   didn’t work because of (I think) an error on this code (“Filter Functions vs.
   Transforms Functions” paragraph): `trans=”first_name=strtoupper(first_name)”`
 * Not being a coder, I did not realize at first, but I suppose it’s a variable 
   attributing a value to itself.
 * All the best.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/does-sorting-must-be-case-sensitive/#post-7620776)
 * Be careful not to have curly-quotes in the shortcode.
 *  Thread Starter [Theo](https://wordpress.org/support/users/dubeux/)
 * (@dubeux)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/does-sorting-must-be-case-sensitive/#post-7620786)
 * Yep, thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Does sorting must be case-sensitive ?’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [case](https://wordpress.org/support/topic-tag/case/)
 * [cfdb](https://wordpress.org/support/topic-tag/cfdb/)
 * [sorting](https://wordpress.org/support/topic-tag/sorting/)

 * 4 replies
 * 2 participants
 * Last reply from: [Theo](https://wordpress.org/support/users/dubeux/)
 * Last activity: [9 years, 9 months ago](https://wordpress.org/support/topic/does-sorting-must-be-case-sensitive/#post-7620786)
 * Status: resolved