W wxdqz New Member Aug 20, 2008 #1 hi, i'm using sql server 7 and i have a text field that i want to sort alphabetically in a SQL query. i tried using ORDER BY but sql server says i can't use it with text fields. does anyone know how i should do it? -sonny
hi, i'm using sql server 7 and i have a text field that i want to sort alphabetically in a SQL query. i tried using ORDER BY but sql server says i can't use it with text fields. does anyone know how i should do it? -sonny
