Please see mock query below, IF 1 is not valid I want '1 does not exist' message to return but if 1 is a valid value and 0 rows can be returned, say for a set day, I want another error message, e.g. '2', is this possible?

```
DECLARE @1 
DECLARE @Date

SET @1 
SET @Date

IF @1 IN SELECT A FROM Table

SELECT

-- *Run Query here* - Would like if 0 rows a message to also appear here. 

ELSE 

'1 does not exist'

```