SQL – convert HEX messages from F00165.GDTXFT to string (JDE ) Home › Forums › Tech › Database › SQL – convert HEX messages from F00165.GDTXFT to string (JDE ) Tagged: EnterpriseOne, HEX, JD Edwards, JDE, Messages, SQL, Work Center This topic contains 0 replies, has 1 voice, and was last updated by Udar Gromov 1 year, 3 months ago. Viewing 1 post (of 1 total) Author Posts 2018-05-16 at 16:15 #5662 Udar GromovKeymaster This is how you convert HEX text stored in BLOB feild F00165.GDTXFT into normal text. –2019-05-15 TU F00165 –MS SQL – read/convert HEX F00165.GDTXFT in into text SELECT GDTXFT, CAST ( CAST ( GDTXFT AS VARBINARY(MAX)) AS NVARCHAR(MAX)) [TEXT] FROM F01131, F00165 WHERE GDOBNM = 'GT01131' AND GDTXKY = ZZSERK We are converting BLOB into VARBINARY and then VARBINARY into NVARCHAR. This statement was tested on MS SQL Server 2012. Result: if double conversion from HEX to text is good, you should see is totally useless messages that batch job has completed successfully. This is an example of converted text value stored in F00165.GDTXFT: To: 99900001@EnterpriseOneInternalMailbox, CC: The following OneWorld job has completed successfully. Report: R57030051 Version: V200V022 Host: OCHPXA1Q Originator: OCHPXA1Q Submit Date: 5/13/2019 Page Count: 661 RE: JD Edwards EnterpriseOne Work Center Author Posts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.