DECLARE @TRUSTOR VARCHAR(5)
SET @TRUSTOR = ‘‘

IF @TRUSTOR IS NULL
  BEGIN
    SELECT ‘IS NULL‘
  END
IF @TRUSTOR = SPACE(5)
  BEGIN
    SELECT ‘‘‘‘‘ = SPACE5‘
  END

-- 执行结果：‘‘ = SPA