if exists(select 1 from kodak.tOnlineClient where UserGuid = 'e540b9bc-3c19-469e-b3ee-362a228911a2' and (comments is null or comments != 'web login user'))beginend
declare num number; begin select 1 into num from kodak.tOnlineClient where UserGuid = 'e540b9bc-3c19-469e-b3ee-362a228911a2' and (comments is null or comments != 'web login user'); exception when no_data_found then ... end;
num number;
begin
select 1 into num from kodak.tOnlineClient where UserGuid = 'e540b9bc-3c19-469e-b3ee-362a228911a2' and (comments is null or comments != 'web login user');
exception
when no_data_found then
...
end;