SQL Server Convert Business Central BLOB Value to Text in Transact-SQL with SQL CLR This blog post is for you if you're looking for a way to get the text values of a BLOB field directly from a SQL query without having to modify the Business Central code base.