Hi all,

How to convert the field colomn value like 018.000 into SQL Sql server
data in the same format.(The custom format in EXCEL is 000.000)

regards,
Sivaraman.S

That depends...

you must consider that SQL Server is a data back-end, so it's only purpose
is to *store* data, not to *present* data.

If you want to store the data exactly the way you want to present it to
users, you must convert the values to VARCHAR.

On the other hand, if you must calculate using the data you've stored, then
use your presentation front-end to show the values as desired. This is the
correct place to do this anyway.

HTH,
www.sportbootcharter.com
Axel Dahmen




----------------------------
"Sivaraman.S" <SivaramanS (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:92D1B4C1-7E9C-4CCB-A8F2-0F7CB1EC352F (AT) microsoft (DOT) com...