U
user3131560
Guest
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...
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...