Another way of doing the same thing for SQL is to make a column for sorting and pad all numbers with zeros. So, 12R57B will become 0000012R0000057B.

When selecting the data, I was expecting the zero values to be returned as 0.00 or 0, but they were returning as .00.<BR>So, I changed some fields to numeric (8,2), hoping that would help.

What does text field actually mean? Find out inside PCMag's comprehensive tech and computer-related encyclopedia.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption code in this post as well.