Last post Jul 10, 2011 06:03 PM by march11
Jul 08, 2011 08:52 AM|cenk1536|LINK
I am reading an excel sheet and converting it to an XML. The problem is I would like to convert the decimal separator. How can I do it?
Here is sample data from excel:
But I want them as folloes:
Jul 10, 2011 06:03 PM|march11|LINK
look up the replace function...
'string_expression1' , 'string_expression2' ,
This example replaces the string cde in abcdefghi with xxx.
SELECT REPLACE('abcdefghicde','cde','xxx') GO
Here is the result set:
------------ abxxxfghixxx (1 row(s) affected)
SELCT REPLACE ('yourstring','.',',')