<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Yes, cast or convert to an (unsigned) integer should do the trick. The functions should concatenate the string at the first non-digit.<br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Angelo Bertolli <angelo.bertolli@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> CLUE talk <clue-talk@cluedenver.org><br><b><span style="font-weight: bold;">Sent:</span></b> Monday, December 8, 2008 5:51:08 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [clue-talk] SQL question anyone?<br></font><br><br><div class="gmail_quote">On Mon, Dec 8,
2008 at 7:43 PM, David L. Willson <span dir="ltr"><<a rel="nofollow" ymailto="mailto:DLWillson@thegeek.nu" target="_blank" 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>
</div></div></div><br>
</body></html>