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]=>數字
Jenny:
陽光令人愉快,雨水令人振作,
風聲令人奮起,雪花令人興奮,
沒有所謂的壞天氣!!
只有不同的好天氣!!