I tried to create a test tag with the following query:
SELECT substring(Desc2, 26, 4) cast(STRING as binary) FROM Journal WHERE Event_Type='EVENT' AND Module='B89F1-BATCHID' ORDER BY Date_Time DESC;
It is not working. If I remove the cast statement, the query works. How do I combine both statements to work correctly?