[clue-talk] SQL question anyone?
David L. Willson
DLWillson at TheGeek.NU
Tue Dec 9 12:22:22 MST 2008
I think cast is an ANSI SQL function. I'll try it. Thanks, Brian and Angelo.
----- Original Message -----
From: "Brian Gibson" <bwg1974 at yahoo.com>
To: "CLUE talk" <clue-talk at cluedenver.org>
Sent: Tuesday, December 9, 2008 10:52:31 AM GMT -07:00 US/Canada Mountain
Subject: Re: [clue-talk] SQL question anyone?
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
_______________________________________________
clue-talk mailing list
clue-talk at cluedenver.org
http://www.cluedenver.org/mailman/listinfo/clue-talk
More information about the clue-talk
mailing list