You have to know what the comma designates, is it visual separation between hundreds and thousands or is it a decimal place in the native language settings?
………………………………………………………………… Stephen Russell – Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 > -----Original Message----- > From: DotNetDevelopment@googlegroups.com > [mailto:dotnetdevelopm...@googlegroups.com] On Behalf Of David Shen > Sent: Wednesday, April 15, 2009 7:42 AM > To: DotNetDevelopment@googlegroups.com > Subject: [DotNetDevelopment] Re: how to convert > > > No easy way...because is has ',' in it. Try to remove it, then use > CAST or CONVERT > > > On Wed, Apr 15, 2009 at 8:37 PM, vikas arora > <vikas.arora....@gmail.com> wrote: > > hi every one, > > > > i face a problem in sql server2000 > > > > when i convert a varchar value '12,234' to int > > > > plz help > > > > > > -- > Best Regards, > David Shen > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.287 / Virus Database: 270.11.57/2060 - Release Date: > 04/15/09 06:34:00
