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.
share string comparison
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Mon Mar 20, 2006 2:03 pm
share string comparison
What's the next?