Well,

If you execute this code alone, how many records are returned?

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

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

FROM sysfiles

More than 1.

So which one do you want to use to set the variable to?