Re: Data style?

From: Wendy W (wendy_wrp_at_wrpworld.com)
Date: 02/03/05 

Date: Wed, 2 Feb 2005 16:44:43 -0800

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

Relevant Pages

  • Re: Data style?
    ... shown with an integer variable @int and the getdatefunction ... I can't format the data grid ... >column to my desired format, ... >Therefore I need to format the fields in SQL statement. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Formatting data in a SP - Access Format() function replacement
    ... try the following in the query analyser ... Simon ... "Chris Strug" wrote in message ... > function so I can't format the data as if it were being fed to controls on ...
    (microsoft.public.sqlserver.programming)
  • Re: Using a stored procedure once
    ... database would no longer be in an appropriate format for them), ... you might as well run the script straight through ... > query analyser. ...
    (microsoft.public.sqlserver.server)
  • Re: Date value filtering out 0 in day!!
    ... reserved word, and using reserved words can lead to all sorts of problems. ... My regional settings was set to m/d/yyyy> so fixing that should fix the problem. ... >> Unless you apply an explicit format, Access gets its date format from the>> Regional Settings. ... I don't understand why that would prevent you from returning any>> values in your SQL statement. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant use dd/mm/yyyy format
    ... mm/dd/yyyy format in SQL statements. ... > I have since found that I cannot use the dd/mm/yyyy date format, so I am now> wondering if I can use an SQL statement to apply criteria to open a form to> specific records. ... > Dim stLinkCriteria As String ...
    (microsoft.public.access.formscoding)