Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
There is no trim() function, I guess if you know how many spaces you could possibly use SUBSTR function, but best would be to fix the UPES to not return the value with the extra spaces _________________ John McDonald
RETIRED
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum