CONCAT / LOWER / REPLACE in MYSQL Query

[xiaochris]

Hi,

I'm trying to execute the following query,when creating new data source

SELECT LOWER(CONCAT('asset2_',REPLACE(AssetType,' ','_'))) FROM assettype2

However, I'm getting these errors.

Error #1088 and #1099

any help?

[HighAley]

Hello.

Did you try to run this query on your mysql database? Is it right?
Could you also specify which version of our product you use?

Thank you.