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?

Outcomes