>
>Hi Wendy,
>
>The formatting of the output of a query is entirely up
to the client. If
>you access the same data using Query Analyser,
Enterprise Manager, Access
>and some other tools, you'll already see a variety in
formats used, as
>each of these tools has it's own defaults.
>
>Best, Hugo
>--

On Tue, 1 Feb 2005 20:39:35 -0800, Wendy W wrote:

>Hi, I would like to change the data output style
>generated from the SQL query. So, how can I go about
>doing it? Example : display 59766 as 59,766 and also
>datetime as date.
>
>Please help....thanks a lot!
>

Wendy W wrote:

>>Hi Wendy,
>>
>>The formatting of the output of a query is entirely up
>>
>>
>to the client. If
>
>
>>you access the same data using Query Analyser,
>>
>>
>Enterprise Manager, Access
>
>
>>and some other tools, you'll already see a variety in
>>
>>
>formats used, as
>
>
>>each of these tools has it's own defaults.
>>
>>Best, Hugo
>>--
>>
>>
>
>
>Thanks, Hugo but my situation is slightly different here.
>I'm supposed to display records in a data grip (ASP.NET)
>using the SQL statement. I can't format the data grid
>column to my desired format, the grid is dynamic.
>Therefore I need to format the fields in SQL statement.
>
>How can this be solved?
>