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

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