On 12/10/2017 13:49, Vlad Khorsun via Firebird-devel wrote: > 12.09.2017 15:33, Adriano dos Santos Fernandes wrote: >> On 12/09/2017 08:46, Magnus Johansson wrote: > ... >>> SELECT FIELD_UTF_SV_CI_NUM >>> FROM TABLE_T >>> WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' >>> ORDER BY 1; >>> FIELD_UTF_SV_CI_NUM >>> =================== >>> 1 >>> 2 >>> 10 >>> 20 >>> a >>> A >>> aa >>> Aa >>> AA >>> b >>> =================== >>> Not the expected result. >>> Where did the 'B' go? >> >> This should be verified. > > Adriano, did you investigate it ? May i help somehow ? >
SQL> SELECT FIELD_UTF_SV_CI_NUM CON> FROM TABLE_T CON> WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' CON> ORDER BY 1; FIELD_UTF_SV_CI_NUM ==================== 1 2 10 20 a A aa Aa AA b B So what is the problem? Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel