I hope you have already tried just plain-old "ORDER BY field_name" in your query. What is wrong with the default order presented? Can you show an example of how the ORDER BY did not solve your problem along with an example of what it should have been for your situation?
Thanks in advance, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Scott Fletcher" <[EMAIL PROTECTED]> wrote on 07/27/2004 05:29:05 PM: > I'm having a little bit of a trouble with the use of the SQL function... > What I have here is a webpage that show the row of data, the web user > get to click on the field to sort the row by the field name. So, when I > use "order by char(field_name)", the data doesn't turned out right in > alpha-numeric in ascending order... > > > > --snip-- > > Debug Test (WM Account) 1 > > ABC Company > > Riverknoll A C > > SDFONE'sdf > > SeaWater > > --snip-- > > > > I would like the first few letter of each row be in correct > alpha-numeric order regardless of what character is there in the data, > like (, ), ', ?, etc... > > > > Thanks, > > FletchSOD >
