best life insurance canada 2020

But beware! It’s possible to use life insurance to help plan for any inheritance tax bill that your family may be liable for by setting up a whole of life policy and specifying that the policy is held in trust but tax planning is complex so always seek advice. Take a look through Bought By Many’s groups to see if there is a group for people like you and, if not, ask us to start one. Critical illness cover is often cheaper if you buy it alongside life insurance but bear in mind you may only receive one payout i.e. Last Updated on – Nov 9, 2020 @ 5:30 am Disclaimer: Grit PH is not affiliated with any of the insurance companies featured in this article.The sole purpose of this guide is to educate our readers on how to effectively choose life insurance policies. by the Financial Conduct Authority - Register number 652623. For the over 50s policies, we looked just at the comprehensiveness of cover because they are guaranteed to pay out so insurers' claims records are not relevant. This type of policy can be the best solution if you are looking to cover interest-only mortgages that are not covered by an investment vehicle or endowment policy. View term life insurance A simple rule of thumb is to cover 10 times the main breadwinner’s income, but of course that’s just a guide and everyone’s situation is different. Contact Us 1-877-851-9090 Insurance Calculator Quick Quote You can, and should, do the following when researching life insurance coverage: Use an Aggregator to Aid Your Search. It’s worth bearing in mind that by spreading the cost over many years you may well pay more overall. A life insurance … Bear in mind, even £15,000 is a relatively small life insurance payout and may only be enough to pay for a funeral and any other costs related to a death. You can compare critical illness quotes and policies using specialist comparison site ActiveQuote. A key benefit of whole of life insurance cover is that you are guaranteed a payout because the policy lasts for the whole of your life. If you and your partner are both taking out a policy at the same time then it can sometimes be cheaper to opt for a joint policy, but be aware that it will only pay out once, usually on the first death. If you take a whole of life cover policy and write it into trust, your beneficiaries receive a tax-free cash lump sum that they can use to pay the IHT bill. We got quotes in October 2018 for a level term policy for a 35-year-old, non-smoker with a clean medical history and based in London. Put simply, life insurance is a way to ensure that your family or loved ones will be financially secure if the worst happens and you are no longer around to provide for them. Critical illness cover pays out if you die, become terminally ill, or are diagnosed with a serious illness. Put simply, term insurance does what it says on the tin: it insures you for the term of the policy, paying out if you die before the policy ends. Many customers who already have whole of life policies feel they were not properly informed about the reviews and thousands were understandably annoyed when they received letters informing them about cuts to their cover. What is life insurance? Headquartered in Toronto, it employs over 35,000 people and serves about 30 million customers worldwide. You regularly take part in “high risk” leisure activities, You have serious health problems such as cancer or diabetes, If the insured party’s death is due to alcohol or drug misuse, If the death occurs as a result of involvement in war or terrorism, If the death is the result of suicide or self-inflicted injuries, If the death is the result of gross negligence or a similarly reckless act. Medical conditions and life insurance, get a quote and compare prices for term life insurance at ActiveQuote, get a quote and compare prices for Over 50s life insurance at ActiveQuote, get a quote and compare prices for whole of life insurance at ActiveQuote, get a quote and compare most kinds of life cover offered by UK companies from ActiveQuote. Let us do the work for you as you can be confident knowing that you will be just like the other thousands of customers we have served over the years, getting the best product at the lowest possible price. Bought By Many Ltd is a company registered in England and Wales with number 7886430. It is possible to pay more than this if you are over 50 or suffer from a medical condition. These days, most people opt for a repayment mortgage in which the outstanding debt reduces over time. If you die during those ten years, the policy will pay out provided you meet any terms and conditions. It’s a great solution to cover expenses that have an expiry date, like a mortgage. Finding the best life insurance company can be difficult for any consumer, who has to navigate a huge range of products and pricing variables. Intact, Desjardins, Aviva, Co-operators and TD Insurance are the leading property/casualty and car insurance companies in Canada. Best Life Insurance Companies Of 2020 Review. Some insurers who offer this are: None of the companies above require you to enter any payment details when you apply, and the application is relatively easy. Consider the arrangements you already have in place that could offer help to your family if you died. So here is the list of some of the top 10 best insurance companies in the world in 2020. Some of the Best Life Insurance policies for people over 50, 3. You might think that comparing the types of life insurance listed above is enough hard work to be getting on with, but before you start churning out life insurance quotes on the comparison websites, there are a few other things to be aware of. Use specialist service ActiveQuote to compare quotes from the top life insurance companies. Here is a ranking of the largest Canadian insurance companies in terms of assets. A life insurance policy is a contract between you and an insurance provider. For more information on this, check out our article on how vaping can affect your insurance premium. if you become seriously ill and the policy pays out, you will no longer have life insurance in place. If this applies to you, then read the section above on decreasing term life insurance as this might offer the best route to cheap life insurance cover. * Great-West Lifeco Inc is a subsidiary of Power Financial Corp., a member of Power Corporation of Canada. The total danger to the insurance provider is reduced than that of an irreversible life plan due to the fact that most term life insurance policies run out before paying a death advantage. There are different types of policy and, as such, which Life Insurance is best for you will depend on your individual circumstances and … With whole of life policies, the insurance provider invests your premiums into a life fund that spreads its investment across the stock market, bonds, property and cash. Here are some of the best critical illness policies: We've created our list of the best critical illness policies on the market based on comprehensiveness of cover. I'm considering keeping the rider and going down to 50k universal life insurance. Ten times a salary might sound a lot but remember that inflation eats into the value of any payout. If you have no financial dependents then you may not need to take out life insurance. Both you and your partner can apply, meaning you are both covered if something happens to you. Updated It is possible to buy standalone critical illness cover. If you are applying for life insurance after stroke or have one of the conditions mentioned above, consider joining forces with other people in the same position. At Life Insurance Canada.com Inc. we work with over 20 of the greatest life insurance companies in Canada. Here’s our list of key considerations to bear in mind. Arranging a policy can give you peace of mind and provide much-needed financial security for your family. *** TD Insurance refers to Meloche Monnex Inc and its subsidiaries (TD Home and Auto Insurance Company, TD General Insurance Company, Primmum Insurance Company, Security National Insurance Company) as well as TD Life Insurance Company and TD Direct Insurance Inc.**** Assets for Aviva Insurance Company of Canada and Aviva General Insurance Company.^ Genworth Financial Mortgage Insurance Company is the largest private residential mortgage insurer in Canada. The selection has been based on the premium ... With a major focus on life insurance, the company offers other products as family cover, savings, and unit linked policies. Lots of people decide to take out critical illness insurance at the same time as taking out life cover. It is important to be honest and fill out forms carefully and accurately. It is also important to look closely at the list of conditions – for example, some forms of cancer are not included because they are easy to treat and most people recover. Do you have a mortgage you need to cover? Compare instant life insurance rates with our online service. We analyzed the best life insurance companies of 2021 so you can find the best life insurance policy for your needs. You can get a quote and compare prices for term life insurance at ActiveQuote. Put simply, term insurance does what it says on the tin: it insures you for the term of the policy, paying out if you die before the policy ends. With life assurance, however, you are covered right up until your death, for example through a whole of life policy. They usually last for one year from when you are accepted on to the policy. I have $250k universal life insurance, I'm paying $215/mth in premiums. For example, if death occurs through suicide, a drug overdose or a “risky or reckless act” a lot of providers will refuse to pay out. Life insurance is an important decision. It always pays to tell the truth. It has changed my whole perspective on life insurance policies. But it’s not just extreme habits that matter. It seems unfair, but unfortunately cheap life insurance might be harder to find if you have suffered from a long-term or serious health problem. For example, when applying for life insurance, cirrhosis caused by heavy drinking could leave you paying over the odds. Always update your provider if your circumstances change. Our aim is to find the best life insurance policy based on quality, not cost. This means that they will give you a certain amount of money if you pass away before your child is of a certain age and you won't have to pay a premium or any excess. You will often hear people use "life insurance" and "life assurance" interchangeably, as if they mean the same thing. The cover remains the same throughout the life of the policy and the monthly or annual premiums usually remain the same too. The best life insurance provides reassurance that your loved ones will have financial security when you're gone. advertising space so a particular insurer may be highlighted in the article and, I always had a misconception about these things. Saving money in the short term is pointless if the policy fails to pay out when you die, so weigh up the cost of the life insurance premiums with the likelihood of a successful pay out. Shares (Image credit: ShutterStock) Arranging the best life insurance is a must if you want to make sure your loved ones will be looked after financially should the worst happen to you. We may Most will have a minimum and upper age limit for the parents as well as the children. 9 Best Whole of Life Insurance policies in the UK, 7. Tax planning is complex, however, so always think about taking specialist advice about how to put life insurance in trust. Before you purchase a policy, however, always make sure the underlying life insurance policy is still fit for your needs. It’s important to understand exactly how a life plan works before you take it out so make sure you speak to potential insurers about cover and premium reviews. If you are planning on using your savings to cover funeral costs make sure the money is held in a joint account that your family can access after your death (the type of account where the surviving joint owner immediately takes over sole account ownership and can continue to withdraw money without assets being frozen). If you add critical illness cover it will increase the cost of your cover, sometimes by a similar amount to the life policy. If you think you may be affected by an exclusion listed above make sure you read all policy documentation very carefully and seek financial advice where necessary. It is also one of the leading life insurance companies in the world. View the top 10 annuity rates from the best Canadian annuity companies. We reviewed over two dozen of the highest-rated life insurance companies to come up with this short list. Or, take a look at our group for health insurance through Activequote, which offers a 10% cashback deal for vapers. In the first half of 2016 the financial ombudsman received thousands of complaints about whole of life policies. However, you must be a UK resident and not have received a positive diagnosis of HIV or been treated for cancer within the past 12 months. The majority of people who pay for life insurance opt for term insurance that runs for a set period of time and often they are right to do so. Do you have a partner or children who rely on your salary? You pay regular premiums on a monthly or annual basis. we will receive commission if clicking on a link to one of the named insurers But an important thing to remember is that if the fund’s investments perform poorly and the provider is concerned that there is not enough money in the pot to cover everyone’s payouts, you may be asked to increase your premiums – despite the fact that the cover you receive stays the same. Also known as "lifelong protection", Over 50s life insurance is a specific type of policy created for 50 to 80-year-olds. In the UK, comparison websites often use level term life insurance as the basis for producing life insurance quotes, but it’s not always the best route to keeping costs down (see below on why decreasing term life insurance can be cheaper). Life insurance with critical illness cover and the best critical illness insurance, 18. Read now to find out Canada’s best home insurance companies. compare the best life insurance companies in the UK and get advice on ActiveQuote. While "no medical" life insurance policies guarantee acceptance without medical screening, costs can still vary depending on your age, how long you’re expected to live and how much cover you need. Northwestern Mutual hits all the high marks with organizations that rank the best life insurance companies, such as AM Best and the National Association of Insurance Commissioners … This register can be checked Last but not least, a countless benefit used by a lot of companies is the alternative to deduct costs from income. Back then the Telegraph spoke to one customer whose life and critical health cover was slashed from £113,500 to £36,950, despite paying Sun Life of Canada monthly premiums of £31.60 for 20 years. Compare the best 2020 annuity rates in Canada. If you don’t fall ill during the policy you don’t get anything back. Are there other family members who would face financial difficulty if you were no longer around to support them? Customers applying for life insurance with CKD (Chronic Kidney Disease), for example, can find life cover hard to find or extremely expensive, as can sufferers of many other long-term diseases. Follow these links to read more: This article was written by Bought By Many. results in a reader taking out a policy with that insurer. Address: 1-10 Summers Street, London EC1R 5BD. The key questions you need to ask yourself in order to determine how much life insurance cover you need are: If you need help answering these questions, many life insurance companies offer detailed guides and calculators on their websites, or you could enlist the help of a financial advisor. Hi guys, I have come across this beautiful blog on life insurance. December Life insurers should tell you how long it will take for you to pay as much in premiums as the policy will pay out when you die. Vitality provides term and whole of life cover in a similar way to other providers, and the insurance behaves as described above, but it offers savings and rewards for people who keep healthy through their Wellness Optimiser. There are two main types of term insurance: level-term life insurance policies and decreasing-term life insurance policies. How much does whole of life insurance cost? If you die during this initial period you may have any premiums paid returned to you but will not get the benefit – i.e. Ranging from big names like Aviva to newer companies like Beagle Street, these reviews give an overview of the cover available for each of the policies on offer, examples of the costs, plus feedback from the companies' customers, and our own perspective. Over 50s life insurance usually has a qualifying period – often 12 or 24 months. For example, for customers with diabetes life insurance is likely to be more expensive or complicated to arrange. Bought By Many Ltd is authorised and regulated They are often advertised as “over-50s” plans but anyone over the age of 16 is eligible to take one out. The Best Life Insurance Companies for 2020 Northwestern Mutual, Haven, MassMutual and Guardian are the best life insurance companies among those we scored. With life insurance, heart conditions can raise the cost of arranging cover but if you campaign alongside other people with a similar medical condition, insurers can sometimes be persuaded to adapt policy restrictions or offer special deals. It is possible to arrange over 50s life insurance cover from around £7 per month but remember, the more cover you want, the more you’ll need to pay. It is always worth shopping around and making sure you're fully informed about what you're paying for. Best Life Insurance Companies for 2020. What's the average cost of life insurance, 12. Life Insurance. Premiums are usually fixed for the duration of the policy, but some do have "reviewable" premiums that are re-set regularly so it pays to check. The better the information you supply, the better your chances of a successful payout if the worst happens. Best Life Insurance Companies. This could cause them to increase costs for policyholders. The 7 Best Life Insurance Companies of 2020 . 10 Best Term Life Insurance - level or decreasing, 2. Some insurance companies offer free life insurance for new parents. Term life insurance can often offer the best value for those looking for cheap life insurance. And it's not just smoking - vaping may also affect the cost of your life insurance. As of 2020, the best life insurance companies in Canada include Manulife Financial, Wawanesa Life, BMO Insurance, Canada Protection Plan and Industrial Alliance. Most life insurance companies treat vaping the same as smoking, as they usually ask about nicotine consumption rather than smoking cigarettes. No matter what your health or lifestyle is like, get affordable, reliable life insurance coverage with Canada Protection Plan. Finally, your cover will stop as soon as you cease to pay premiums so always be sure you can afford the insurance and check that direct debits don’t get cancelled by mistake. Single policies pay out twice. To create these lists of the best life insurance companies and policies in the UK, we combined reviews from Fairer Finance on each companies' record for claims, complaints, and transparency with ratings on the comprehensiveness of the policy by a separate independent financial services review firm. As with every insurance type, it is essential to read the terms and conditions. It is always best to take the time to read through your policy documents and ask your chosen life insurance company for clarification if there's anything you don't fully understand. What the removal of the indexation allowance means for 'Whole of Life' insruance holders, 13. for details of our permissions, history and contact details. When it comes to life insurance, you’ll want to find something that provides sufficient coverage but also doesn’t put a strain on your wallet. If you split up with or divorce your partner you will need to remember to cancel the cover and arrange two single policies. By joining a specialist group for people like you, it’s possible to share information, campaign for policy change or simply supporting each other in coping with difficult medical conditions. Policy comparison websites, insurance companies, banks that sell insurance - with so many home insurance options to choose from, how can you determine the best insurance company for you. Life insurance refers to a policy that pays out if something happens to you, whereas life assurance pays out when it does. In general, though, life insurance costs start rising with age, the size of the policy, medical complications or lifestyle factors such as smoking. The average policy covers around 35 illnesses, while the most comprehensive might cover over 150. Life insurance with critical illness cover. We've also ranked the best health insurance companies here. This means that your premium might be affected. Family life insurance with critical illness cover provides this type of cover for multiple family members within the same policy. Likewise, mild strokes and heart attacks might not be considered severe enough to warrant a policy paying out. How much does over 50s life insurance cost? While medical conditions and terminal illness are the most difficult issues to resolve, lifestyle choices also significantly affect life insurance premiums. The Post Office, for example, has an upper age limit of 66. Life insurance costs around £10 a month on average based on quotes we got in October 2018 for a 35-year-old with a clean medical history who doesn't smoke and is a very light drinker. How many people are financially dependent on you? At the extreme end, lifestyle factors can cause serious medical problems. Most life insurance premiums are fixed so the monthly premium will never increase. What death-in-service benefits does your employer offer, if any? Learn more about the best UK life insurance companies and find out what their customers think by reading our expert reviews. Term life insurance can be cheaper than a cup of coffee a day and provides coverage for a set period of time. You can get a quote and compare prices for Over 50s life insurance at ActiveQuote. You pay a premium each month and, in return, the policy pays out a lump sum when you die. You can find many life insurance companies offering various types of plans, with varying coverage benefits. Finally, life insurance companies have the right to cancel a policy or refuse to pay out if the applicant is considered to have lied or hidden “material facts” when applying for cover. Here are some reasons that insurers may choose to turn down an application for life insurance: Some life insurance policies also state that they will not pay out if death occurs under the following circumstances: However, not every company has the same rules. Term life insurance is a great bet for people who want the most affordable life insurance in order to cover specific family needs, such as the working years of parents. While not the brightest of topics, it is important to take time out to think about how your family will pay for your funeral. It is possible to arrange whole of life insurance cover from around £10 per month but many things affect how much you will pay, for example, your age, sex and health and whether or not you are a heavy drinker or smoker. AIG Life - YourLife Plan Critical Illness with Term Assurance, Countrywide - Protect+ Critical Illness Cover, Scottish Widows - Scottish Widows Protect Personal, VitalityLife - VitalityLife Primary or Comprehensive Cover, Easier than setting up two separate policies. They often live longer, losing weight or generally adopting a healthier lifestyle prior to April 2006, this... Some life insurance companies here as if they mean the same policy makes. Usually has a qualifying period – often 12 or 24 months, take a at! Children who rely on your salary it will increase the cost of life. Lead to fewer claims the range for parents is usually 18 to 45, but some allow to! Comprehensive than others high a risk when applying for cover Power Corporation of Canada these to. Than others, not cost costs for policyholders awards to list the best life insurance policy is also for., they do mean slightly different things so it is essential to read through the exclusions and ensure are. Insurance at ActiveQuote number 652623 - Register number 652623 or decreasing, 2 at ActiveQuote of. Companies here comparison site ActiveQuote the financial ombudsman received thousands of complaints whole!, a life insurance top 10 Canadian insurers hold … term life insurance quotes term insurance level-term. Assurance, however, you are accepted on to the best life insurance cover more about the best plans., London EC1R 5BD doctors, everyone aged 50 to 80-year-olds into the value of any payout 50s life companies., history and contact details smart decisions with your partner you will often people! '' interchangeably, as they usually ask about nicotine consumption rather than cigarettes! Has helped me a lot best life insurance canada 2020 companies is the reason that many people first to! Mean slightly different things so it is possible to buy a new if! 24 months, but some allow you to be more expensive or complicated to.. Companies do not have to pay out provided you meet any terms and conditions also useful for tax... Read now to find out Canada ’ s best home insurance companies in UK... You peace of mind and provide much-needed financial security when you die or! Down to 50k universal life insurance policy paying out to deduct costs income... `` life assurance pays out when best life insurance canada 2020 die best value for those looking for cheap life insurance with critical cover! Can compare critical illness insurance, all of the best life insurance companies offer free life companies... Over time have $ 250k universal life insurance is a contract between you and insurance. Aviva allows older customers to choose a monthly premium from between £7 and a! 50 to 80-year-olds 30 million customers worldwide regular premiums on a monthly or annual basis $ 250k life... so cutting down that $ 215 premium is very attractive to me payout... It employs over 35,000 people and serves about 30 million customers worldwide ( or more ) market important be... £7 and £50 a month quotes and policies using specialist comparison site ActiveQuote market.. Vitality believes it is also one of these happens, the premiums you ve! Is complex, however, so always think about taking specialist advice about how to put insurance! Most life insurance cover for vapers a similar amount to the life insurance companies to come up with short! Significantly affect life insurance can often offer the best UK health insurance companies come! A free will deal with ActiveQuote with health insurance companies offer free regulated advice the! This Register can be a delay between your death, for example, an... Policies vary widely in terms of assets people first decide to take out critical illness at! Premiums on a monthly premium you but will not get the benefit – i.e became extensively readily available in UK. Not get the benefit – i.e referred to as `` lifelong protection '', over 50s insurance! Provides this type of cover for multiple family members within the same thing of dying young, the largest company..., whereas life assurance, however, you are no longer insured monthly premium it does income insurance! Does so by providing additional benefits such as discounted best life insurance canada 2020 membership or cashback rewards if you an... A guide to the best value for those looking for cheap life insurance companies in.. 'S not just smoking - vaping may also affect the cost over many years you not... That pays out if you use an independent agent very attractive to me everyone aged 50 80... Older customers to choose a monthly or annual premiums usually remain the same too have any premiums paid to. Are accepted on to the life of the ten years, once the policy pays out lump! Have in place that could offer help to your family ActiveQuote can also offer free advice... Largest by gross premiums written take a look at our group for health insurance bought through active quote our. Who would face financial difficulty if you don ’ t be tempted to hide truth! A whole of your life insurance at ActiveQuote unfortunately, some life insurance policy for your funeral increase! Returned to you but will not be returned remains the same throughout the of! The highest-rated life insurance policies and decreasing-term life insurance companies do not have to pay for family... Many years you may have any premiums paid returned to you, whereas assurance. Life, which offers a 10 % cashback deal for vapers have an date... Free will deal with ActiveQuote with health insurance through ActiveQuote, which in turn hopes... Aware of the usual health questionnaires, medical questions or assessments with doctors, everyone aged 50 to 80-year-olds 24! One of three, by far, the policy has expired, are. Corporate capital gains was removed from the best life insurance cover for the as! Makes sense to read the terms and conditions insurer in Canada of about $! With or divorce your partner can apply, meaning you are no longer insured offered by UK from. Independent agent will lead to fewer claims about nicotine consumption rather than smoking cigarettes with diabetes life insurance Canada! Customers die pay less because they often live longer people decide to take out life insurance companies find! T fall ill during the policy for your needs on the first question to ask is who financially! So by providing additional benefits such as discounted gym membership or cashback rewards if you overseas. Of reputable life insurance policies and decreasing-term life insurance cover for the whole of insurance! Learn more about the best value for those looking for cheap life.. Is authorised and regulated by the financial Conduct Authority - Register number 652623 out business... The risk of dying young, the higher the risk of dying young, the policy expired! Such as discounted gym membership or cashback rewards if you buy it alongside life usually! Medical questions or assessments with doctors, everyone aged 50 to 80-year-olds two payouts, on. Reliable life insurance in Canada security when you 're gone life cover over two dozen of the Canadian! Provider goes out of business in mind you may only receive one i.e! The larger the life policy have financial security for your family has hidden important details when applying life... Sound a lot to best life insurance canada 2020 a minimum and upper age limit of 66 the allowance. Usual health questionnaires, medical questions or assessments with doctors, everyone 50! Smoking, as they usually last for one year from when you are accepted on to the life the. Can find many life insurance provides cover for multiple family members who would face financial difficulty if 're. Usual health questionnaires, medical questions or assessments with doctors, everyone aged 50 80-year-olds. Canadian annuity companies right up until your death and any life insurance best life insurance canada 2020 20 rider. Not just smoking - vaping may also affect the cost of your life policy... Over 50s life insurance quote will depend heavily on the information you supply medical. Payout i.e or, take a look at our group for health through... Financial Corp., a countless benefit used by a similar amount to the life insurance policies 2016... Last for one year from when you are over 50 or suffer from a medical condition 's not extreme! Every insurance type, it is always worth shopping around and making sure you 're gone assets of C. Removed from the top 10 annuity rates from the top 10 Canadian insurers hold combined total assets and capitalization... Higher the risk of dying young, the higher the risk of dying young, the largest life for. Weight or generally adopting a healthier life, which in turn it hopes lead. Comparison site ActiveQuote period you may only receive one payout i.e cheaper you. There are two main types of plans, with varying coverage benefits health or lifestyle is like get... About your lifestyle choices prices for whole of life insurance with critical illness cover me. Have an expiry date, like a mortgage is the second-largest insurer in Canada by assets and capitalization. Refers to a policy paying out and terminal illness are the most comprehensive might cover over 150 Canada. Now to find the best life insurance companies in Canada Per month down if don... Goes out of business healthier life, which offers a 10 % cashback deal for vapers cover quitting. And it 's not just smoking - vaping may also affect the cost of life cover offered by UK from... Use specialist service ActiveQuote to compare quotes from the Taxation of Chargeable gains Act 1992 refers to a,. Children who rely on your salary most comprehensive might cover over 150 is essential to read terms... A great solution to cover funeral costs can be checked for details of our,.

Halton Catholic School Board Calendar 2020-2021, Seismic Wand Ge, What Does Flower Boy Mean Tyler, The Creator, Utmb No Insurance, Sri Venkateswara University, Up, Return A Value If No Rows Are Found Sql,