I have an SSIS package that imports a csv file. For some reason, when it goes into the SQL table, there are SOME values that start with " and I want to get rid of them but don't konw the TSQL to say delete " at the beginning of the value.
I double checked the CSV file and there are not spaces or special characters before the import.
Thanks in advance. Phil
------------------------------ Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2 Be kind to the newbies because you were once there.
Thanks but that didn't work because I'm not trying to get rid of blank spaces. Some values are starting with the quote " and I want to actually get rid of them like an update or something and not just say a Select statement to ignore the ". I know I can get rid of the " in the Select statement by just using REPLACE like this.
Select REPLACE (value, '"', '')
Does anyone know how to actually delete just " found in values or update so it will replace " with ''?
Thanks!
------------------------------ Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2 Be kind to the newbies because you were once there.
Remove blank space from the beginning
Posted - 10/15/2012 : 12:02:48
