title: How can I convert text with a localized number format into a number in MS SQL Server?
body: <p>Let's say I have a number in the german number format "1,00" which is equal to 1.0 in the en-US locale.</p>
  
  <p>Is there a built-in way to convert this text in T-SQL to the corresponding number? It seems like CONVERT and CAST accept only numbers with '.' as the decimal separator and I see no way to tell them otherwise.</p>
  
  <p>I was thinking about simply replacing ',' with '.' but this gets ugly if I have a german number with thounsands separator like "1.000,00".</p>
  
  <p>Doing the conversion after retrieving the "wrong" SQL result is not an option.</p>