update endereco 
set logradouro = substring(logradouro, 2, len(logradouro)-1)
where substring(logradouro, 1, 1) = ' ' and len(logradouro) > 1
GO