DECLARE @addr varchar(50), @len int
SELECT @addr = '市西五区北区39号楼1单元201室'
SELECT @len = LEN(@addr)
DECLARE @a varchar(2)
WHILE @len > 0
BEGIN
SELECT @a = SUBSTRING(@addr, @len, 1)
SELECT @a, ASCII(@a)
SELECT @len = @len - 1
END
DECLARE @addr varchar(50), @len int
SELECT @addr = '市西五区北区39号楼1单元201室'
SELECT @len = LEN(@addr)
DECLARE @a varchar(2)
WHILE @len > 0
BEGIN
SELECT @a = SUBSTRING(@addr, @len, 1)
SELECT @a, ASCII(@a)
SELECT @len = @len - 1
END