Is this correct way to do it

DECLARE @clientname VARCHAR (60)

SELECT DISTINCT @clientname = ClientName

FROM tblClient

WHERE ClientNumber

IN

(SELECT ClientNumber FROM tblSystem WHERE SystemNum = @systemID)

SELECT CASE

WHEN @clientName LIKE '_p_'

THEN 3

ELSE 2

END