Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Nepal
    Posts
    32

    Unanswered: Select c_name AS Name

    Hi All,

    Today i started to learn Sybase, and am unable to call AS to change the column name.

    i have quriry : select c_name AS Name from Customers;

    But still in display column showing c_name.

    Any Suggestion.

    Thank You
    Last edited by abdul_zu; 10-03-10 at 11:36.

  2. #2
    Join Date
    Jun 2010
    Posts
    51
    I ran your query and it gave me the desired column name. What version of Sybase ASE are you using?

    Other options you may try:
    Code:
    select c_name Name from Customers
    select c_name "Name" from Customers
    Thanks,
    Meet
    Please always reply to the post if it was helpful. Others may find it helpful.

Posting Permissions

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