Home > IT Answers > AS/400 > AS/400 Query – How to combine 2 fields but delete the null space?
Milahuang99
5 pts.
 AS/400 Query – How to combine 2 fields but delete the null space?
AS/400 administration, AS/400 queries, AS/400 Query
fields a: School , in the fileld a there are 3 null space after school, field b: I choose , now I want to combine filed a and field b by using "||" as a new field, how to delete the null space

Software/Hardware used:
ASKED: February 6, 2009  3:50 AM
UPDATED: February 6, 2009  10:48 PM
RELATED QUESTIONS
Answer Wiki:
Looks like VARCHAR(FLDA) || FLDB although if you know the length then you could use SUBSTR(FLDA, 25) || FLDB
Last Wiki Answer Submitted:  February 6, 2009  10:48 pm  by  philpl1jb   44,070 pts.
All Answer Wiki Contributors:  philpl1jb   44,070 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _