title: SQL import pipe delimited with some data fields that have have pipe in record
body: <p>I am currently using Bulk insert in SQL to import a pipe(|) delimited which is pretty straight forward.  My problem I am running into is sometimes there are records that include the pipe(|), which will then in return bulk insert breaks it up into two different records.  Below is an example</p>
  
  <pre><code>12343|First Name|Last Name| Address field|Location
  63494|Second First Name|Second Last Name| Address Field with | in it |location
  </code></pre>
  
  <p>My example above, the second record, bulk insert will split the address field because it contains a |.  Are there any suggestions out that I could use to avoid problems like this?</p>
  
  <p>Thanks</p>