Sort DB in Alphabetical order?

Community resources Bugs
#1

I have several product names in a DB:

Children’s DHA (180 Soft Gels)
Children’s DHA (120 Soft Gels)
Children’s DHA (90 Soft Gels)
Children’s DHA (16 Oz. Liquid)
Children’s DHA (8 Oz. Liquid)
Children’s DHA (4 Oz. Liquid)

I want to short them as above however the DB arranges them as follows:

Children’s DHA (120 Soft Gels)
Children’s DHA (16 Oz. Liquid)
Children’s DHA (180 Soft Gels)
Children’s DHA (4 Oz. Liquid)
Children’s DHA (8 Oz. Liquid)
Children’s DHA (90 Soft Gels)

What’s happening is the DB is sorting the numbers from highest to lowest. The end result is it is very confusing for customer’s to find a product. Any ideas on how I can get the DB to sort the way I have the products listed above?

Thanks!

#2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.