MS SQL Server 2008.
I have a stored procedure that recieves and xml document and uses it to update a table.
I have a line of code:
[Tumorhojd] = @xmlData.value('(BRUM-registret/OriginalData2012/Tumorhojd)', 'real'),
that updates a REAL column.
It works when the value of Tumorhojd is a number that has a decimal point, but not when it contains a decimal comma.
We are using decimal comma's in our data.
Is there a way to set up the conversion so that decimal comma is accepted?