title: How to extract the float part from nvarchar in SQL Server
body: <p>I have a field contains characters and numbers in different format
  like</p>
  <pre><code>f v/45.23698,sdfsdf
  25.369xzczxc xcvxv
  erwer ewrwr 2.36
  </code></pre>
  <p>I want to extract the numbers part with decimal (any number of decimals) omitting any characters in any case and any symbols ! @ # $ % ^ &amp; * ( ) - _ = + / * \ | ? : &quot;</p>
  <pre><code>45.23698
  25.369
  2.36
  </code></pre>
  <p>if there is any errors like</p>
  <pre><code>df df , 23.45.67 dfg fdg
  </code></pre>
  <p>I want to return 23.45 only (ignoring the others) or 23.4567 (ignoring the second decimal point) it doesn't matter at all .. the two solutions are acceptable</p>
  <pre><code>23.45
  23.45678
  </code></pre>
  <p>both are acceptable</p>