For the op
1. First way is to go back to residency
2. Or, find a small hospital that's in the middle of nowhere just to get your feet wet, and then apply to a bigger hospital later.
This all depends on how many years out of school you are...3+ years, go back to residency, 2 years and under..try your luck with a smaller hospital. Most hospitals lack trust in the rph's ability to understand lab works or make on the spot interventions with MDs if they are out in retail for too long.
Every hospital is different and it depends on the clinical service required for that specific hospital. Some hospitals will make you into a glorified data entry person, while others require you to go on rounds every morning (yes even as a staff pharmacist).
Also your success depends on how proactive you were in retail. If you provided A+ MTM services to all your pts, read all the newest articles and bathed yourself in pharmacy information day in day out, then you shouldn't have a problem jumping into a hospital. However, I also knew retail RPHs with 28 years of experiences who circled NDC numbers all day, and forgot that a lisinopril is an ace inhibitor(he said it was a calcium channel blocker...yeahh....).
I've worked at Target for 9 months before becoming a clinical staff pharmacist. This was at a time when residency wasn't the end all be all. I feel like I have lost so much knowledge just by working in retail...but I sure knew the ndc number for metformin...
My current hosptial job is much more fulfilling. We calculate and titrate pulmonary hypertension meds, vancomycin, amioglycosides, insulin/pumps and iron dextran just to name a few. We also go on rounds with MDs, teach pt about warfarin/tikosyn/all heart failure meds, and participate in journal clubs with the pgys.
In contrast, I was trying to figure out how to get people to sign up for target credit cards in retail, while getting yelled at by the store managers because my credit card scores were too low...
My advice, get out of retail asap and get yourself some hospital experience so your choices wouldn't be so limited 10 years down the road. Sure the pay is slightly less, but at least you opened yourself to many more opportunities and freedom. Retail will always be there for you, but it's really hard to re-learn everything you have lost in retail after 10 years.