select a.*
from albaranes_cab a
where (cast(a.fverificacion as date) = '01.10.2010')
select a.*
from albaranes_cab a
where (cast(a.fverificacion as date) between '01.10.2010' and '01.10.2011')
select a.*
from albaranes_cab a
where (cast(a.fverificacion as date) between :LIFECHA and :LSFECHA)
-- a LIFECHA y LSFECHA se le pueden pasar parámetros del tipo Date