I think the important distinction is believing in the possibility of some sort of intelligence behind the universe, and believing that one of the current major world religions are correct. It's the latter that would motivate somone to act much differently, as Brad suggests. Agnostics and atheists alike would probably put equal credence in the specific beliefs in God that are currently in place, and in that case aren't terribly different from one another.