Re: Example of right justifying a character field.

I love using SQL for stuff, but I think this is a lot more complicated than the EVALR opcode - not a BIF, right? An example from the manual - Name is a 20-character alpha variable.

    evalr Name = 'Johann Strauss';
    // Name is now '      Johann Strauss'

This has been around since at least 7.1, so far as I know.

Regards
Vern

On 3/26/2023 2:49 PM, Jonathan Ball wrote:

I tend to do all of this kind of activity in SQL whenever possible.

   dcl-s   char_15   char(15);
   dcl-s   char_30   char(30);
   dcl-s   char_7    char(7) inz('STUFF');   // char_7 = 'STUFF '

   exec sql
   set :char_15 = lpad(rtrim(:char_7), length(:char_15));  // char_15 = '          STUFF'

   exec sql
   set :char_30 = hex(:char_15);   // char_30 = '40404040404040404040E2E3E4C6C6'

In find SQL built-in functions intuitively easier to understand and simpler to use than equivalent RPGLE BIFs, and there aren't always equivalents.

On 2/14/2023 1:04 PM, dfreinkel@xxxxxxxxxxxxxxxxx wrote:

What is a good and simple way to right justify a character field?


I would not like to use a do loop to do this.


Thanks


Darryl Freinkel

A4G

Telephone: 770.321.8562 Mobile: 678.355.8562