With standard UK and Irish horse racing when you choose SP then it doesn't matter what the price is when you take the horse, it only matters what price your horse is when the race starts - this is what you will be paid out at.

Typically, on the day of the race, UK bookmakers offer a choice between placing a bet at SP, or taking a fixed price.