[clue-talk] SQL question anyone?

[Angelo Bertolli]

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/20081208/b1236876/attachment.html