New line Character on column alias.

• Manish_

  Ten Centuries

  Points: 1070

  More actions

  July 13, 2005 at 10:25 pm

  #102640

  Hi Friends,

  I have the following query, i am using the column alias by this way,

  select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature

  it works fine and i get this output.

  Work Code        Work Nature    

  1                     External                

  2                     Sales                

  3                     Miscellaneous        

  4                     Equipments &Transport

  But my requirement is to break the Column alias in two line with the new line character. as follows

  Work                Work

  Code                Nature         

  1                     External                

  2                     Sales                

  3                     Miscellaneous        

  4                     Equipments &Transport

  PLease guide me .

  Thanks you so much.

  - Manish

• James Lean

  SSCertifiable

  Points: 5757

  More actions

  July 14, 2005 at 2:44 am

  #574281

  SELECT work_code AS [Work

  Code], work_nature AS [Work

  Nature]

  FROM sb_cm_work_nature

  If you're doing this from Query Analyzer you will need to be in "results to text" mode to see it.

  -----
  JL

• Dylan Peters

  SSC Eights!

  Points: 916

  More actions

  July 15, 2005 at 1:59 pm

  #575036

  However this will give you:

  Work

  Code Work

  Nature

  --     --

  x        y

   

  Unfortunately this is a presentation issue that should be done at the presentation or application layer.

  Dylan

  Dylan Peters
  SQL Server DBA