SQL获取大小写字母

[sql] 
--大写  
--SELECT CHAR(65)  
--SELECT CHAR(90)  
  
--小写  
--SELECT CHAR(97)  
--SELECT CHAR(122)  
  
DECLARE @lngUpperLetter INT  
DECLARE @tUpperLetter TABLE(strLetter NVARCHAR(10))  
  
SELECT @lngUpperLetter=65  
WHILE(@lngUpperLetter<=90)  
BEGIN     
    INSERT INTO @tUpperLetter  
    SELECT CHAR(@lngUpperLetter)  
    SELECT @lngUpperLetter = @lngUpperLetter+1  
END  
  
DECLARE @lngLowerLetter INT  
DECLARE @tLowerLetter TABLE(strLetter NVARCHAR(10))  
SELECT @lngLowerLetter=97  
WHILE(@lngLowerLetter<=122)  
BEGIN     
    INSERT INTO @tLowerLetter  
    SELECT CHAR(@lngLowerLetter)  
    SELECT @lngLowerLetter = @lngLowerLetter+1  
END  
  
SELECT * FROM @tUpperLetter UNION ALL  
SELECT * FROM @tLowerLetter