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

[user3131560]

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

Continue reading...