alphabetical order, ignore symbols
I set up my site using DataAssist.
The products looks great and are showing up correctly on the page except for one minor thing. The products are not appearing in alphabetical order.
For example, it appears like this.
We would like it to appear like this
If the product name has a single quote before it, it throws off the alpha order. How do I get the database to alpha-order everything, ignoring the quote? Any advice or direction would be helpful.