Yep, I know Gaffney pretty well, being a Spartanburger myself. I think previous posters are accurate -- you'll find the Triangle area to be more liberal and tolerant and more expensive. Downtown Raleigh is really fun, and it'll seem like more of a "real city" to you. $850 is doable for a 1 bedroom. It won't be luxury, but it'll be nice.
Every time I go home to visit my dad in Spartanburg, I can't get out of that place fast enough. It makes me realize how spoiled we are here. Upstate SC is sooooo provincial in its thinking, has a realievely low educational level, and is way too conservatively Protestant. It feels like I'm stepping back to 1985 every time I go there. The only thing worth going home for, besides Dad, is a big a**ed Hash-A-Plenty from the Beacon!!