Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Data type for storing commas,full stop

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-29 : 14:46:34
Gurus
What data type should i use to store fullstops and comas in the data in the column.

regards
Nitin

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-29 : 18:00:15
You can use char or varchar




KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-30 : 03:03:55
Also make sure that you dont store comma seperated values format

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-06-30 : 05:20:37
And I hope this isn't currency or number data.

Nitin - If you want to check you're doing the right thing, post some sample data and we can advise you...

Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page
   

- Advertisement -