How to convert a String from OEM to ANSI - during load time

[#1]

Hello !

Is there any function that can help me convert a string written in OEM character set to ANSI character set during LOAD TIME ?

I know that the LOAD statement can do that.

But say that I'm writing a "IF" statement using some strings written in OEM. I need to convert it to ANSI. Any ideas ?

Thanks !

[#2]

If your LOAD statement is converting, then perform the load, without the IF, and then re-load the resident table, and perform your IF statements on the converted data, then drop the initially loaded table when you're done with it.

[#3]

Thanks.

Feasible but cumbersome.

I'm looking for a more elegant solution.

Thanks anyway !