Greetings! I am currently working on an iOS app and not too well versed in SQLite. Here's what I am trying to do.
I have a table "stations" and the fields "state" populated by US States and "power" which is populated with strings similar to 1.0 kW, 50.0 kW 10.0 kW etc... so the query I need... I need something along the lines of "SELECT * FROM stations WHERE state like '%x%' ORDER BY ..." Here lies the issue. I need to trim kW from the number and turn it into an integer/double/float what have you so that I can order it by power lowest to highest or vice versa... So.... essentially I searching for a antennas in a specific state like "CA" Where x is my placeholder and I'd like to sort them by their power. Any help is greatly appreciated! -- View this message in context: http://old.nabble.com/trim-alpha-numeric-string-so-it%27s-numeric-cast-then-order-tp33711898p33711898.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
