How to convert numbers saved as characters into digits. Is there any Query instruction to convert Characters into Digits? I'm trying to link 2 files, and one of the fields is character in one file and digits in the other, so I can't link them. For example: 00877874 is saved as character in...
Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.