Sand is no different than gravel in one respect- it comes in different grain sizes. I had not done sand for the first 11+ years in the hobby. This changed a couple of years ago when I did my fist sand tank. My motives in selecting the sand were very simple. I was getting involved with Altum angels and was advised by a person who has actually collected them in different rivers explained the sand he had found that look the closest to what he saw in the rivers was CaribSea Torpedo Beach. So I went looking for it. In the process I discovered the difference there can be in sands.
Moonlight Sand/Marine Sand
Average Small Grain Size: 0.1 mm
Average Large Grain Size: 0.3 mm
Sunset Gold
Average Small Grain Size: 0.1 mm
Average Large Grain Size: 0.4 mm
Crystal River
Average Small Grain Size: 0.2 mm
Average Large Grain Size: 0.5 mm
Torpedo Beach
Average Small Grain Size: 0.2 mm
Average Large Grain Size: 1.2 mm
The smaller the grain size, the more easily it can be disturbed into the water column and into your filter. Stuff like play sand or filter sand is not likely to list grain sizes. The other thing to look for is the shape of the grains. Rounded is better, imo.
I have this sand now in a few tanks. Two of those tanks have one and two hang on filters that have pre-filter sponges. I never get sand in any of them. If you can, try shortening the intake tubes so they are farther above the bottom.
Bear in mind that I pay up for the sand I want. Even on sale it runs about 75 cents a pound.