select uploadid,EntryMode from uploads where CASE WHEN @EntryMode='All' THEN EntryMode is not null WHEN @EntryMode='App' THEN EntryMode is null ELSE EntryMode =@EntryMode END
WHERE (@EntryMode='All' AND EntryMode is not null) OR (@EntryMode='App' AND EntryMode is null) OR @EntryMode = EntryMode
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)