How could I Upper case?

[ecabanas]

I have this function upper(itemid) as itemid

I have bad results in this Id's:   Trans_FBC, did not capitalize!!! any idea why?

Thank's

Eduard

[jonathandienst · Accepted solution]

Hi

Your statement is correct. I suspect that the itemid value Trans_FBC is coming in via another load statement. Is itemid used in more than one table in the load?

Hope that helps

Jonathan

[ecabanas]

yes, I think I just found the problem, now i'm trying to eliminate the accents!!! 🙂