Here's an example:

$sql = "SELECT * FROM CUST WHERE LASTNAME LIKE upper(?) AND FIRSTNAME LIKE upper(?)";
$sth = ibase_query( $db_handle, $sql, strtoupper($search_var1), strtoupper($search_var2));
if ($sth) {
if ($row = ibase_fetch_object($sth)) {
//$save_in_variable = $row->FIELDNAME;
}
}
ibase_free_result($sth);

--- In firebird-php@yahoogroups.com, "jackdmason" wrote:
>
> 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.?
>