SQL判斷是否為英文數字

DECLARE @Num varchar(13)
SET @Num = 'GWE1100024RA1'
DECLARE @i int
SET @i = 1
WHILE(@i <= len(@Num))
begin
if(substring(@Num, @i, 1) like '[A-Z]')
PRINT 'Yes'
else
print 'NO'
set @i = @i + 1
end

PS:[A-Z]=>全大寫   [a-z]=>全小寫   [0-9]=>數字