scp does glob files or rather the shell on the other end globs files. You need to escape the meta characters from your local shell of course.