<p>I receive some arguments into a stored procedure. These arguments are NVARCHAR's.</p>

<p>I have a problem, when I need to cast some of these values to FLOATS, because they are being received as e.g.</p>

<p>@VALUE1 NVARCHAR(100)</p>

<p>DECLARE @ChangedValue
SET @ChangedValue = CAST(@Value1 AS FLOAT)</p>

<p>E.g. @Value1 = "0,001"</p>

<p>Gives me a problem, as it expects "0.001"</p>

<p>I can't change the format of the input, but can I somehow change it on the SQL-server side? By changing all "," to "." instead?</p>

<p>Best regards, Kenn</p>

You could use
```
@VALUE1 = REPLACE(@VALUE1, ',', '.')
```
This does seem a horrible thing to do though!