Hi--

A simple question on making my where clauses case insensitive with FB 2.nn.

is there an easier way then setting up the SQL like the below?

select * from table
where
upper(field) like '%UPPERCASE LOOK FOR%'
order by
upper(field)

is there a speed issue? that is...will that resolve as fast as:

select * from table
where
field like '%LOOK FOR%'
order by
field

thanks again!
regards
kelly