Hi Huarachon,
I’m sorry to hear about your experiences with Sleep Number but I appreciate you taking the time to share them.
You can see my thoughts about airbeds in general in this article. While any mattress can be a good match for a specific person because each person’s needs and preferences or the criteria that are most important to them can be very different … in general terms I would tend to avoid them unless there is a very compelling reason that an airbed would be a better choice for you in “real life” (outside of the many “marketing stories” that you will hear about them) than the many other options or types of mattresses that are available to you.
If you are committed to an airbed and you are convinced that there are no other types of mattresses that will meet your criteria then there are some other airbed options that are listed in post #3 here that may be much better quality/value choices than Sleep Number/Select Comfort.
Now that you are starting over again the best place to start your research is the mattress shopping tutorial here which includes all the basic information, steps, and guidelines that can help you make the best possible choice … and perhaps most importantly know how and why to avoid the worst ones.
Two of the most important links in the tutorial that I would especially make sure you’ve read are post #2 here which has more about the different ways to choose a suitable mattress (either locally or online) that is the best “match” for you in terms of “comfort” and PPP that can help you assess and minimize the risks of making a choice that doesn’t turn out as well as you hoped for and post #13 here which has more about the most important parts of the “value” of a mattress purchase which can help you make more meaningful quality/value comparisons between mattresses in terms of suitability (how well you will sleep), durability (how long you will sleep well), and the overall value of a mattress compared to your other finalists (based on all the parts of your personal value equation that are most important to you).
If you let me know your city or zip code I’d also be happy to let you know about any of the better options or possibilities I’m aware of in your area as well.
Phoenix