H4b0s wrote: Something like:
SELECT count(*) as y0_ FROM Drzava this_ WHERE this_.Aktivan = @p0 and lower(substr(this_.Oznaka,1,2)) like @p1; @p0 = 'True', @p1 = '%a%' solved my problems (same environment - NHibernate & Firebird) Regards. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider