Lines Matching refs:substr
62 # Check out the substr() function
65 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
68 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
71 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
74 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
77 execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
80 execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
83 execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
86 execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
89 execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
92 execsql {SELECT substr(a,1,1) FROM t2}
95 execsql {SELECT substr(a,2,2) FROM t2}
116 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
119 execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
122 execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
125 execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
128 execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
131 execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
134 execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
137 execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
140 execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}