char to varchar
Moderators: chulett, rschirm, roy
char to varchar
We had issues in moving data from char to varchar fields. I have trimmed all char before writing to varchar. Is there anything else I should be looking at? thx
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The three-argument version of Trim() will remove them.
Performance Tip
Initialize a stage variable to Char(0) and do not derive it. That way the Char() function is evaluated only once per run, rather than once per row.
Performance Tip
Initialize a stage variable to Char(0) and do not derive it. That way the Char() function is evaluated only once per run, rather than once per row.
Code: Select all
Trim(InLink.TheString, svNUL, "A")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: