If you want children, but you realize your partner is sterile, would you leave him/her?

If you don't have the means to pay for assisted fertility services.
Would you adopt, or accept the situation, or would you look for someone else to have kids?
Updates
+1 y
I'm glad no one answered yes lol.
I agree with everyone here, a worthy partner to spend my life with is more important than having a bio child.
If you want children, but you realize your partner is sterile, would you leave him/her?
Post Opinion