[RESOLVED] Help with the SQL Query

[vuyiswam]

Good Day All

I have the Following SP

ALTER PROC GET_BASED_PATTERN
(
@SUBJECT VARCHAR(30),
@Pattern  nvarchar(128) output 
)
AS
SET @Pattern = (SELECT TOP 1 TERM.[CYCLETEMPLATES]FROM tbl_term TERM 
INNER JOIN dbo.TBL_ACTV v
on TERM.ID = V.TERM
INNER JOIN  DBO._Subjects S
ON V.TERM = S.[LEVEL]
WHERE CODE = @SUBJECT)
SELECT 
CASE 
WHEN LEN(@Pattern) > 1 THEN @Pattern
ELSE '00000000'
END

It returns

00000000 and Null

and NUll at the Bottom if the len is not greater than 1. i want it to return 00000000 if its like that.

Thank you