title: Format raw varchar field to phone
body: <p>I'm helping a friend with a winforms app loaded with crystal reports (two things I generally try to avoid so pardon my ignorance).  Anyhow if I have a varchar database field:</p>
  
  <pre><code>2123456789
  </code></pre>
  
  <p>And want to display it on the **crystal**report as:</p>
  
  <pre><code>(212)-345-6789
  </code></pre>
  
  <p>How would I go about that without changing the stored procs, or the database data type (not trying to open that can of worms).  From what I've been apply to surmise if it was a numeric or int field then I would be able to use the Format Object number tab.  However this is not an option due to the datatyping. </p>
  
  <h2>EDIT</h2>
  
  <p>My goal is Formatting the data in the crystal report or back end code of the crystal report  not the database or t-sql.  Thanks</p>