How does a beginner turntable compare to digital ?


I am thinking of trying my first turntable with a 300-500$ turntable such as Rega P1 or Pioneer. How does that sound comparing to digital playback ? For example compare to Rega Apollo CD player ? what kind of differences can I expect ?

I am using Rega Brio 3 amplifier and Harbeth C7-es2 speakers.
Excellent midrange is a must to me. I am listening mainly to folk, bluegrass, jazz, small chamber musics some ballad rock.
vqlong2000
..it all depends on your entire system and room. You may like your CD player better after all is done.
I was initially very disappointed when I tried what you are contemplating. Lots of good advice above, especially those who point out that a turntable also requires a cartridge, phono preamp, cable... and an isolation stand or similar device. It adds up. I reached c. $6K on the turntable setup before it clearly bested my ancient cd system (Pioneer PD-65/Muse Model 2/Genesis Digital Lens). But now I listen almost exclusively to records (again). It takes a lot of time and effort to get a turntable to live up to its potential, they are not plug and play like digital. I could not recommend going down that road unless you already have a worthwhile record collection.
It all depends how much enjoyment...or conversation piece equipment one wants to own...but truth be told...it is kind of a misnomer that you have to spend thousands to fully understand vinyl...similiar to Mac computers...there are those that must justify their purchases...and having esotoric gear falls into that...I would find a decent, clean used table in your are for cheap(far less that the $400 for a rega...and see if it floats your boat...in you have any analogue inclinations this will bring it out...from there you can upgrade...note: i have several used record stores in my area so going second hand is very easy and cost effective...if you live in a more rural area and have to purchase new via mail order, etc...that kind of defeats the purpose of used savings...
Expect nothing in advance - just try it. I agree with the recomendation of Pro-Ject Debut III. Add to this Pro-Ject phono box and Pro-Ject speed controller.