--- In firebird-support@yahoogroups.com, Radu Sky <skysword76@...>
wrote:

>
> majstoru wrote:
> > --- In firebird-support@yahoogroups.com, Radu Sky <skysword76@>
> > wrote:
> >> majstoru wrote:
> >>> Is there any way to put IF condition or something like that to
> > prevent
> >>> NUll or 0 as result into InPrice?
> >>
> >> CASE statements wouldn't help?
> >>
> >> Radu
> >>
> >
> > Hi Radu,
> >
> > Sounds great if it is possible, do you have a sample or a sintax

of a

> > CASE into SQL script!
> >
> > Thanks again!
> >
>
>
> INSERT INTO RK (RKId, ArtId, ArtName, ArtBarcode, InPrice, OutPrice,
> SpecPrice, Qty)
> SELECT :ID, ArtId, ArtName, ArtBarcode, InPrice, OutPrice,
>
> CASE
> WHEN COALESCE(InPrice,0)=0 THEN <your alternate value here>
> ELSE (OutPrice / InPrice) * 100
> END,
>
> Qty
> FROM (SELECT ArtId, ArtName, ArtBarcode, (SELECT Price FROM

QtyActual

> WHERE Object = 1 AND ArtIdqty = ArtId) AS InPrice, (SELECT

AVG(Price)

> FROM QtyHistory WHERE Object = 1 AND ArtIdqty = ArtId) AS

OutPrice,

> Qty
> FROM ArticleTable
> WHERE ArticleTable.Id = :PARAM1)
>
> HTH
>
> Radu

Thanks Radu, that is a finall solution for my SQL statement!