Re: [sqlite] trim alpha numeric string so it's numeric cast then order

[Mr. Puneet Kishor]

On Apr 18, 2012, at 11:01 PM, starvingpilot wrote:

> 
> Also, I need to select from a specific state like "CA"  Where is that part in
> the query?


SELECT state, power || ' kW' power 
FROM (
        SELECT          state, Cast(Rtrim(power, 'kW') AS 'numeric') power 
        FROM            stations 
        WHERE           state = 'CA' 
        ORDER BY        power
);


--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users