Syntax for selecting particular column value from memo field in progress database

Question

I'm using progress database,I have a field doc_desc which is memo. In that I need to retrieve data starts with @. Can anyone help with the syntax in Java. I wrote my code like this:

SELECT LEFT(Doc_Desc,LEN(Doc_Desc) - CHARINDEX('@', Doc_Desc, 1)) from PUB.GLDOCHDR where Doc_Desc like '%@%'

but this is giving me a syntax error

Answer 1

OpenEdge (Progress) does not support a "charindex()" function. You are probably wanting to use INSTR() or SUBSTR() or SUBSTRING().

The documentation is here: http://documentation.progress.com/output/OpenEdge113/oe113html/wwhelp/wwhimpl/js/html/wwhelp.htm#href=Data%20Management/SQL%20Reference/06dmsrfFnctn.138.083.html