Hi all,

I have a little problem with a SELECT statement inside
a Stored Procedure.

A SELECT statement is getting some values with INTO
to some variable. Everything works fine, but if
the result of the SELECT statement is more the 1 record,
an SQL error "Multiple Row in singleton select" will appear.

Is there an easy way to read only the first record from
the result ? It doesn't matter if there will be more the one.

Thanks

Gerhard J. Schober

--------------------------------------------------
DevCon Engineering
P.O.Box 179
9490 Vaduz
Principality of Liechtenstein
--------------------------------------------------
Web: www.devcon.li
EMail: gjschober@...
--------------------------------------------------
4C6B 5D10 84C0 48FD CE80 9CA1 0C74 34EA FA6C 6965
--------------------------------------------------