aciu, uzvedei ant reikiamo kelio ;)

-- 
Honda Civic '00 EK3 1.5 Vtec-E
 
"Linas Petkevičius" <linas@NONONOinfonova.lt> wrote in message news:hjsdre$6ll$1@trimpas.omnitel.net...
> Neturiu Access po ranka, bet jei gerai pamenu sintakse, tai:
> 
> SELECT ArtGroup.ID, ArtGroup.Code, ArtGroup.Description, IIF 
> (isnull(artGroup.fkBitmap);0;1)  FROM ArtGroup;
> 
> 
> 
> "Kaksht" <kaksht@cianetikrasmuilas.com> parašė naujienų 
> news:hjscs7$5i3$1@trimpas.omnitel.net...
>> jei nesunku uzmesk aki ar taip ar dar selecta reiktu rasyti? cia 
>> supaprastintas variantas tik isrinkimo
>>
>> SELECT ArtGroup.ID, ArtGroup.Code, ArtGroup.Description, (IF 
>> (ArtGroup.fkBitmap = NULL) OR (ArtGroup.fkBitmap = '0')) '1' ELSE 
>> (ArtGroup.fkBitmap) )
>> FROM ArtGroup;
>>
>> -- 
> 
> 
>