<div>
It wasn't clear but I believe you have the values as string/varchars? &nbsp;So here's an example of how you might convert to decimal.<br />
<br />
declare @strval varchar(50), @decval decimal(10,2)<br />
<br />
set @strval = '1 400,50'<br />
set @decval = convert(decimal(10,2),Repl<wbr />ace(Replac<wbr />e(@strval,<wbr />',','.'),'<wbr /> ',''))<br />
select @strval as OldVal, @decval as DecVal
</div>


<div>
the problem with this is that if I have a US formatted number is going to mess it up<br />
&nbsp;like 1,000.0
</div>


<div>
Remove the comma at all as below:<br />
<br />
set @strval = '1 400,50'<br />
set @decval = convert(decimal(10,2),Repl<wbr />ace(Replac<wbr />e(@strval,<wbr />',',''),' ',''))<br />
select @strval as OldVal, @decval as DecVal 
</div>


<div>
Ah, the original message didn't indicate you had BOTH US and Polish. &nbsp;Then, as indicated, just switch on by examining the format. &nbsp;If the value has a space, then treat it as Polish and convert it. &nbsp;If not, treat it as US and do no Replace(); just convert it to decimal.
</div>


<div>
Thanks a bunch this worked great
</div>


<div>
<div class="content wysiwyg-content">
I hvae &nbsp;alot of decimal string formatted in the polish locale and SQL server is erroring everytimwe I try to cast as decimal. <br />
<br />
here si an example 1 400,50<br />
<br />
Any help would be appreciated.<br />

</div>
</div>


I hvae  alot of decimal string formatted in the polish locale and SQL server is erroring everytimwe I try to cast as decimal. 

here si an example 1 400,50

Any help would be appreciated.


It wasn&#39;t clear but I believe you have the values as string/varchars?  So here&#39;s an example of how you might convert to decimal.

declare @strval varchar(50), @decval decimal(10,2)

set @strval = &#39;1 400,50&#39;
set @decval = convert(decimal(10,2),Replace(Replace(@strval,&#39;,&#39;,&#39;.&#39;),&#39; &#39;,&#39;&#39;))
select @strval as OldVal, @decval as DecVal

the problem with this is that if I have a US formatted number is going to mess it up
 like 1,000.0

Remove the comma at all as below:

set @strval = &#39;1 400,50&#39;
set @decval = convert(decimal(10,2),Replace(Replace(@strval,&#39;,&#39;,&#39;&#39;),&#39; &#39;,&#39;&#39;))
select @strval as OldVal, @decval as DecVal 

Ah, the original message didn&#39;t indicate you had BOTH US and Polish.  Then, as indicated, just switch on by examining the format.  If the value has a space, then treat it as Polish and convert it.  If not, treat it as US and do no Replace(); just convert it to decimal.

SQL Server Polish Formatted Strings

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.