title: Deleting Characters Before Integer
body: <p>pe.fdaddress has strange characters before the number. This is preventing my code from joining properly. Is there any way to remove these characters to run my code properly? The addresses results are null because of this. Thanks</p>
  
  <pre><code>SELECT ca.fdorgunit AS Facility
  , pt.fdmedrecnum AS Account
  , ca.fddos AS DOS
  , pe.fddob AS DOB
  , pe.fdssn AS SSN
  , ad.fdaddr1 AS [Address]
  FROM OPENQUERY (VISION, 'SELECT * FROM ci.tbcase') AS ca
  LEFT JOIN OPENQUERY (VISION, 'SELECT * FROM de.tbpatient') AS pt
  ON pt.id = ca.fdpatient
  LEFT JOIN OPENQUERY (VISION, 'SELECT * FROM de.tbperson') AS pe
  ON pt.fdperson = pe.fdid
  LEFT JOIN OPENQUERY (VISION, 'SELECT * FROM de.tbaddress') AS ad
  ON ad.id = pe.fdaddress
  WHERE ca.fdcasestatus = 'Performed'
  GROUP BY ca.fdorgunit, ca.fddos, pt.fdmedrecnum, pe.fdssn, pe.fddob, ad.fdaddr1
  </code></pre>