<br><div class="gmail_quote">On Mon, Dec 8, 2008 at 7:43 PM, David L. Willson <span dir="ltr"><<a href="mailto:DLWillson@thegeek.nu">DLWillson@thegeek.nu</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
How do I turn values like "2c-lb, 4wr, 38b-t1" into just the numbers that they begin with? In this case, I would want a return of "2, 4, 38" and I would want the 1 at the end of the last datum ignored.<br>
</blockquote><div><br>I think these are database-specific functions. Like Oracles to_number or Postgres' cast()<br><br>Angelo<br><br></div></div>