If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

I am getting errors in T-SQL query... Conversion failed when converting datetime from character string. SELECT roA_tblUser.Email as Email FROM roA_tblUser UNION SELECT roA_tblUserAccount ...