title: Modify and Check Data while using Bulk Insert from CSV file - SQL
body: <p>I'm using method below inserting Data from csv file into SQL.</p>
  
  <pre><code>BULK
  INSERT tblMember
  FROM 'F:\target.txt'
  WITH
  (
  DATAFILETYPE='widechar',
  CODEPAGE = 'ACP',
  FIELDTERMINATOR = ';',
  ROWTERMINATOR = '\n',
  ERRORFILE = 'C:\CSVDATA\ErrorRows.csv',
  )
  GO
  </code></pre>
  
  <p>I need to do two things. First check if All Chars in Column One of CSV file for each row are only Digit and if yes Insert it. and Also I need to add a specific Word before these chars while inserting.</p>
  
  <pre><code>01 - 123,M,A,USA
  02 - H24,N,Z,USA
  </code></pre>
  
  <p>I need to only insert row one, Because Column One is only Digit numbers '123', and I need to add "D" before this numbers and then insert it into SQL. so we have something like this is SQL after insertion:</p>
  
  <pre><code>"D123","M","A","USA"
  </code></pre>
  
  <p>Possible?</p>