AnsweredAssumed Answered

RDBMS query to extract batchID from string

Question asked by RolandCasis on Sep 18, 2020
Latest reply on Sep 26, 2020 by hugo_guilherme

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?