Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

**CLOSED Convert an integer to a string for a JOIN

robert fuschetto

Recommended Posts

Hi Robert, be aware that the examples above can have leading spaces in the A20 result, even though it might not look like it in the HTML output. These leading spaces can be a problem. You can explicitly either right justify or left justify the value of the A20 defined field to match the field you are joining to. You can use the RJUST or LJUST functions to do this.

Documentation link: Using Functions Manual

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...