Try:

declare @tamanho varchar(10)

select @tamanho=substring(name,1,10),

       --CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2))

FROM sysfiles

SELECT @tamanho

or:

declare @tamanho varchar(10)

select @tamanho=

       --substring(name,1,30) as Banco,

       CONVERT(varchar(10),CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2)))

FROM sysfiles

SELECT @tamanho

or:

declare @tamanho numeric(10,2), @banco varchar(30)

select @banco=substring(name,1,30),

       @tamanho=CAST((FILEPROPERTY(name, 'SpaceUsed')* 8)/1024 AS numeric(10,2))

FROM sysfiles

SELECT @banco, @tamanho

Andy