Why the same select from the console and stored procedure gives
different results? Initial params are the same:
PAVADINIMAS_IN = '' & MIESTAS_IN = ''

CREATE PROCEDURE SP_SELECT_KOLEKTYVAI_SEARCH (
PAVADINIMAS_IN VARCHAR (50), MIESTAS_IN VARCHAR (24))
RETURNS (...)
AS
BEGIN
for select k.* , ( select z."Vardas" || ' ' || z."Pavarde" from
ZMONES z where z."Zmogaus_ID" = k."Vadovo1_ID" ) as "Vadovas1" ,
( select z."Vardas" || ' ' || z."Pavarde" from ZMONES z where
z."Zmogaus_ID" = k."Vadovo2_ID" ) as "Vadovas2" , ( select z."Vardas"
|| ' ' || z."Pavarde" from ZMONES z where z."Zmogaus_ID" =
k."Vadovo3_ID" ) as "Vadovas3" from KOLEKTYVAI k
where "Pavadinimas" starting with :Pavadinimas_in and "Miestas"
starting with :Miestas_in
into .....
do
suspend;
END

With the '' & '' params I got an empty dataset, but if I make select
query from the console, I got all matching records. Why is the difference?
Using FB 1.5 rc8

Gediminas