[clue-talk] SQL question anyone?

[Brian Gibson]

Yes, cast or convert to an (unsigned) integer should do the trick.  The functions should concatenate the string at the first non-digit.




________________________________
From: Angelo Bertolli <angelo.bertolli at gmail.com>
To: CLUE talk <clue-talk at cluedenver.org>
Sent: Monday, December 8, 2008 5:51:08 PM
Subject: Re: [clue-talk] SQL question anyone?



On Mon, Dec 8, 2008 at 7:43 PM, David L. Willson <DLWillson at thegeek.nu> wrote:

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.


I think these are  database-specific functions.  Like Oracles to_number or Postgres' cast()

Angelo


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-talk/attachments/20081209/1b44f1d2/attachment.html