Thanks Markus.

Does anyone know whats the performance of this kind of sql?

select *
from customer
where (type = :paramtype) or (Cast('*' as VarChar(3)) = :paramtype)

Does it uses the indexes properly? how about on large table?