Consulting

Results 1 to 2 of 2

Thread: Access Format vs SQLS Convert

  1. #1
    VBAX Expert Imdabaum's Avatar
    Joined
    Jun 2006
    Posts
    652
    Location

    Access Format vs SQLS Convert

    In MS Access I can do a format(Var, "#,###") and get a var with value 1000 expressed as 1,000. I've googled the format and it says that the equivalent for Format in SQLS2005 is convert. But what parameter ensures that a comma separates the ever 3 digits from the decimal?

    What if I want 3 0s instead of 4 as comes by converting to 'money', style=2?
    Can I define my own formatting/converting styles?
    Someday I'll understand everything...
    Even then...I'll still pretend I'm a beginner.

  2. #2
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    Just .02 , but since SQL Server is more for storage than display, you pretty much have to either write your own format udfs (there are plenty of samples available to download) or link the tables to Access and use it as a front end. In a few weeks I'll be working fully with SQL Server Express 2008 (which I'm impressed with), and can share some UDFs. Stan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •