Lines Matching refs:substr

64 # Check out the substr() function
67   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70   execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73   execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
76   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
79   execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
82   execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
85   execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
88   execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
91   execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
94   execsql {SELECT substr(a,1,1) FROM t2}
97   execsql {SELECT substr(a,2,2) FROM t2}
118   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
121   execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
124   execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
127   execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
130   execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
133   execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
136   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
139   execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
142   execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}