Results 1 to 2 of 2

Thread: Order By on character field

  1. 06-11-2001, 10:28 PM #1
    Justin Guest

    Order By on character field

    Does ORDER BY work on character data type in SQL Server through ODBC?
    I tried using the SQL Query Tool in SQL Enterprise Manager and it works but using through ODBC I can't get any results.

    Query: SELECT company_id, company_name FROM lt_company ORDER BY company_name

    company_id = integer
    company_name = 30 characters
    Reply With Quote Reply With Quote
  2. 06-12-2001, 01:16 PM #2
    Guest

    Order By on character field (reply)

    Try connecting with Access through ODBC.


    ------------
    Justin at 6/11/01 11:28:00 PM

    Does ORDER BY work on character data type in SQL Server through ODBC?
    I tried using the SQL Query Tool in SQL Enterprise Manager and it works but using through ODBC I can't get any results.

    Query: SELECT company_id, company_name FROM lt_company ORDER BY company_name

    company_id = integer
    company_name = 30 characters
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules