| Subject | php case insensitive field access | 
|---|---|
| Author | jackdmason | 
| Post date | 2013-01-23T20:59:47Z | 
Using the php interface is there a way to specify in the query the data fields are to be case insensitive such that a query such as:
SELECT * FROM CUST WHERE LASTNAME LIKE 'mcg%' AND FIRSTNAME LIKE 'jo%'
will find Josh Mcgee, josh McGee, Joe McGrath, john mcGregor, etc.?
            SELECT * FROM CUST WHERE LASTNAME LIKE 'mcg%' AND FIRSTNAME LIKE 'jo%'
will find Josh Mcgee, josh McGee, Joe McGrath, john mcGregor, etc.?