I'm trying to determine how (if possible without writing extension) to split a single column by a character value - for example
Column AgeRange has values such as 20-30, 40-50 I'd like to do something like... select substr(agerange,1,instr(agerange,'-')-1) as StartAge, substr(agerange,instr(agerange,'-')+1) as EndAge I don't see an instr function supported in sqlite - any ideas? ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag