2017. 12. 10. 12:29 keltezéssel, Adriano dos Santos Fernandes írta:
How can you order by a blob? It's an error anyway.

For example:
SELECT * FROM TABLE1 ORDER BY (CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FROM 1 FOR 40) AS VARCHAR(40)))

Gabor

------------------------------------------------------------------------------
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

Reply via email to