sqlBulk.WriteToServer(excelReader);
string removeCharacter = "Select Replace('Price', '$ ', '') FROM #temp";
sqlCommand.CommandText = removeCharacter;
I'm importing an excel file into sqlserver, I'm trying to remove the $ sign before I import the field into the database. The above code just does nothing $ sign still imports, also no error.