On 15 Dec 2003 at 11:39, Gediminas wrote:

>sp_select_kolektyvai_search('',''), always got an empty dataset.
>But if I execute such script:
>
>select * from KOLEKTYVAI where "Pavadinimas" starting with '' and
>"Miestas" starting with ''
>
>got full dataset? why there is a difference in results?

This is well-known bug with indices and comparsions. If table is
not very big, drop the index and you'll get right results. Otherwise
you have to live with it.

SY, Dimitry Sibiryakov.