Re: Change the display text format

From: Devil Garfield (DevilGarfield_at_discussions.microsoft.com)
Date: 09/01/04 

Date: Tue, 31 Aug 2004 20:29:21 -0700

Dan,

Actually, I am a newer for the TSQL ... so can you give me some hints to
tackle this problem !!

Thanks a lot!!

"Dan Guzman" wrote:

> 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.
> >
>
>
>

Loading