most likely, it should be a separator. replacing should be safe.
On Thu, Apr 16, 2009 at 11:23 PM, Stephen Russell <sruss...@lotmate.com> wrote: > > 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 > > > -- Best Regards, David Shen
