You could create it as a UDF call without too much fuss. Probably
better off using WaitForSingleObject (presuming windows here), and set
the timeout to whatever delay you pass in. WaitForSingleObject is
generally much more efficient than polling a clock.

--- In firebird-support@yahoogroups.com, Adomas Urbanavicius
<adomas@i...> wrote:

> Hi,
> Are there any supported functions in SQL to do
> command delay :
> delay(msec)
> or
> wait(msec) ?
>
> lets say is system service stored proc :
> while not (exists (select * blah blah)) do
> begin
> delay(1500);
> end
> If I run such statement without delay it would consume all CPU.
>
> Adomas