Thanks that solved my problem

Muthu Annamalai

> > Hi,
> >
> > I am having problem in using First. Here is my SP
> >
> > SELECT FIRST 3 RECEIPT.RECEIPTNUMBER
> > FROM RECEIPT
> > WHERE RECEIPT.CUSTOMERID = :CUSTOMERID
> > INTO :RECEIPT1, :RECEIPT2, :RECEIPT3;
>
> FOR
>
> SELECT FIRST 3 RECEIPT.RECEIPTNUMBER
> FROM RECEIPT
> WHERE RECEIPT.CUSTOMERID = :CUSTOMERID
> INTO :RECEIPT1
>
> DO
> BEGIN
> SUSPEND;
> END
>
> Adam
>