Progress Db Charindex Syntax Error

[DaBlue]

I'm trying to create a query in progress DB that gets the name portion off the email address. This is what I have so far:

substring("PUB"."NAME"."INTERNET-ADDRESS", 1, CHARINDEX('@', "PUB"."NAME"."INTERNET-ADDRESS") ) as Name


However, I'm getting a syntax error around the CHARINDEX(...

I'm not a progress guy and knowing SQL is just enough to get me into trouble...

Do you see the error in my ways?

Continue reading...