Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    38

    Unanswered: How to comma a string with SQL statement?

    Hi there,

    I have quite long integer fields and i would like to see them seperated with comma in DBGrid like this :

    Data in DB --> 100000000
    Data in Grid --> 100,000,000

    Can i do this with SQL statements?

    My second question is : I have a DB and stores 2 integer fields.I have 3 predefined fields and 2 of them shows these fields.Can i show the sum of 2 fields in the third field? Like this :

    In DB :

    Field1 Field 2
    ------ -------
    3 2

    In Grid :

    Field1 Field 2 Field 3
    ------ ------- ------
    3 2 5

    Thanks in advance.

    Coolio

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    All of your questions are presentation issues (affecting how information is displayed), not storage/retreival questions (affecting how information is managed). They all can and should be dealt with in the DBGrid instead of in the database.

    -PatP

Posting Permissions

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