Hi Dennis,

try

SELECT FIRST 1 <blablabla>

e.g.

SELECT FIRST 1 from reg_header where customer_code='23232323'


This will return either exactly one record or no records at all.


Best Regards

Stefan

> I want to ask the base with a query and to return me if there is a least on
> record with specific criteria.

--
Stefan Heymann
www.destructor.de/firebird