normally if I want to select within a range of numbers I can do something like this:
sqlite3 $db "select * from SNPS where $Start >= 1 and $Start <= 100000" gives: 1 100 222 1123 1122 etc. how do I do the same select statement where the field are pre-appended with a word and a colon eg "chr19:" here are some sample data points below, how to I do a select statement on that asking to ignore the 'chr19:' and return a listed based the digits eg select * from SNPS where $Start >= 1 and $Start <= 1000" and then returns "chr19:200" Thanks everyone chr19:200 chr19:255492 chr19:255667 chr19:255879 chr19:256903 chr19:257329 chr19:257819 chr19:258037 chr19:258349 chr19:258796 chr19:258820 chr19:258884 chr19:259045 chr19:259317 chr19:259352 chr19:259681 chr19:260122 chr19:260275 chr19:260445 chr19:260476 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
