Dúvida c/Variáveis

Bom dia cara.

Vc tem 2 opções :

[color=green:5b5bdf4487]Declare @nome VarChar(xx), @tur Char(7), @mat Char(4)

SELECT @nome = NOME, @tur = SUBSTRING(NOME,18,7) AS TUR,
@mat = SUBSTRING(NOME,26,4) AS MAT
FROM xxx
WHERE CODPERLET = ´2004/2´ [/color:5b5bdf4487]
OU

Declare @mat Char(4)

[color=green:5b5bdf4487]SELECT @mat = SUBSTRING(NOME,26,4) AS MAT
FROM xxx
WHERE CODPERLET = ´2004/2´ [/color:5b5bdf4487]

[color=red:5b5bdf4487]o q vc não pode fazer é:

Declare @mat Char(4)

SELECT NOME, SUBSTRING(NOME,18,7) AS TUR,
@mat = SUBSTRING(NOME,26,4) AS MAT
FROM xxx
WHERE CODPERLET = ´2004/2´ [/color:5b5bdf4487]
Att,