column alias name with special characters?

[btappan]

First of all I know this is bad practice. It is not my choice to use this, I am forced to because a 3rd party app I need to use requires it in csv files I submit to it. If we could skip all the formalities on why it's wrong, that'd be great. I'm just looking for a way around this.

I have a field named discountprice that I need to apply a column name alias to in a query that has a colon in the middle of it like price:level2

Obviously using price:level2: discountprice in the query builder doesn't work. I was already told to try it in sql view like "discountprice AS price:level2:"and that works, but only until you try to save the query, then it causes an error.

Does anybody have anyway to make it work?

[pbaldy]

Untested, but have you tried bracketing the alias?

[btappan]

Yes, bracketing is unsuccessful as well. Thanks though.

[ItsMe]

If there is not another way then you will probably have to edit the CSV file after it is created.