10_substr.sql File metadata and controls Code Blame 34 lines (22 loc) · 1006 Bytes Raw 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 declare b blob; ...

Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

A new method 'substr' that provides a portable SQL substring statement, in particular overcoming the SQL server requirement for a mandatory 3rd length parameter mnewnham self-assigned this Apr 10, ...