T&B <list.sql-s/[EMAIL PROTECTED]> wrote:
I have some imported data, where some fields contain numbers with commas denoting thousands separators. How can I change these to actual numbers?I tried using CAST, which only works with later SQLite versions, but it doesn't seen to know the comma as the thousands marker. For instance: sqlite> SELECT CAST('1,234,567' AS REAL); 1.0
Your best bet is probably to clean up the data before passing it on to SQLite. Just strip non-digit characters and convert to a number in whatever language your application is written. SQL is ill suited for string manipulation.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
