share string comparison

[wenfei.chen]

I wrote a function which can extract number out from a .ini file, it will return string number like "25". My server job will call this function and assign the output value to a stage variable: stagevar.

My job is to fileter out the records that column DUE is greater than that stagevar. At the begining, I just used DUE > stagevar in constraint, and it didn't work. After one day research, I found out that stagevar is not "25", but ""25"", so I have to use trim(stagevar,char(34), "A") to strip out the extra double quotation.

Hope my post can help someone who is struggling with the data type conversion issue.

[ArndW]

Doesn't that mean that your function return value is also quoted, so it would make more sense to remove the extra quotes in your program so it doesn't get passed to the stage variable in the first place?