create function get_str(@str varchar(100),@replace varchar(100))
returns varchar(100)
as
begin
while left(@str,3)=@replace
set @str=stuff(@str,1,3,'')
while right(@str,3)=@replace
set @str=left(@str,len(@str)-3)
return @str
end
go
select dbo.get_str('@@@AA@@@A@@@','@@@')

DECLARE @T varchar(100)
declare @LEFT_SPCAE_COUNT decimal
declare @RIGHT_SPCAE_COUNT decimal
set @LEFT_SPCAE_COUNT = 0;
SET @RIGHT_SPCAE_COUNT = 0
set @T = '@@@@@@AAA@@@@@AA@@@@@@';

WHILE CHARINDEX('@@@',@T) <> 0 AND PATINDEX('%[^@]%',@T) > CHARINDEX('@@@',@T)
BEGIN
    SET @T = RIGHT(@T,LEN(@T) -3)
    SET @LEFT_SPCAE_COUNT = @LEFT_SPCAE_COUNT + 1;
END

SET @T = REVERSE(@T)

while CHARINDEX('@@@',@T) <> 0 and PATINDEX('%[^@]%',@T) > CHARINDEX('@@@',@T)
begin
    set @T = right(@T,len(@T) -3)
    SET @RIGHT_SPCAE_COUNT = @RIGHT_SPCAE_COUNT + 1;

end

SET @T = REVERSE(@T)
SET @T = REPLICATE(' ',@LEFT_SPCAE_COUNT) + @T + REPLICATE(' ',@RIGHT_SPCAE_COUNT) 
print @T