| **Navigation:**  SQL Driver Properties(General) >====== PROP:ServerCaseInsensitive ====== | [[prop quotestring.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[prop sql 2.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

The SQL drivers assume that the server is set up with //case insensitive// searches, and no longer generate UPPER calls in the SQL code when requested by the Clarion code. To turn off this behavior (force generation of UPPER calls), use **PROP:ServerCaseInsensitive**. When this file property is active (1), you will make the file driver use UPPER for all SQL sent to the backend.

{{notebox.jpg|NoteBox.jpg}}

This property only needs to be set once per connection and can only be done after a connection to the database has been established

**Example:**

Customer{PROP:ServerCaseInsensitive} = 1     !server searches are now all UPPER CASE.