Re: Change the display text format

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 09/01/04 

Date: Tue, 31 Aug 2004 21:11:30 -0500

Formatting column headers and data for display purposes is a task best
handled in the front-end application rather than Transact-SQL. The details
of the solution depend on the language you are using and the format of the
output (i.e. console, html, listview control, etc.). 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Devil Garfield" <DevilGarfield@discussions.microsoft.com> wrote in message 
news:AB133A84-36D0-4A5E-AA36-15B0510F0071@microsoft.com...
> Dear expert,
>
> I create a view as below:
>
> Code:
> Select Studn as NAME, Studs as SEX, Studca as [CHINESE ADDRESS], Studea as
> [ENGLISH ADDRESS] FROM Student_Record
> :
> :
>
> Screen Output:
> NAME     SEX     CHINESE ADDRESS    ENGLISH ADDRESS
> -------     ----      ---------------------    ----------------------
>
> If I want to modified the Screen output as below:
> NAME     SEX     CHINESE      ENGLISH
>                        ADDRESS     ADDRESS
> -------     ----     -----------    ------------
>
> How can I modify the code in order to get this output ???
>
> Thanks very much for all of your concern.
>

Relevant Pages

  • Change the display text format
    ... NAME SEX CHINESE ADDRESS ENGLISH ADDRESS ... If I want to modified the Screen output as below: ...
    (microsoft.public.sqlserver.programming)
  • Re: Change the display text format
    ... one could render the result as html in an ASP ... >>> Select Studn as NAME, Studs as SEX, Studca as, Studea ... CHINESE ADDRESS ENGLISH ADDRESS ... >>> If I want to modified the Screen output as below: ...
    (microsoft.public.sqlserver.programming)