dcsimg
Results 1 to 2 of 2

Thread: To remove the white space between column name

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    To remove the white space between column name

    Hi all,
    i am trying to get the detials from the tables from sybase DB,here is my query,

    select MEMNAME,SCHEDTAB,CMDLINE from tablename,

    and i get output as shown below,


    MEMNAME SCHEDTAB
    CMDLINE

    XXXXXXXX XXXXXXXX
    XXXXXXX
    YYYYYYYY YYYYYYYY
    YYYYYYY

    i need to remove the white space between the column , so that output looks good and i can easily copied over to excel sheet,

    any help highly appreciated

    Mohammed Rashid.

  2. #2
    Join Date
    Jan 2011
    Posts
    3
    if the columns are string just concatenate them like
    :

    select st1+str2 from test

Posting Permissions

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