rpad with space not working

(2 posts) (2 voices)

Tags:

No tags yet.

  1. jasmondluk, Member

    select 'dbr.text', rpad('abc',25,char(32))

    trying to do above but none space is appended at the end

  2. myDBR Team, Key Master

    HTML suppresses spaces by default. You can use:

    select 'dbr.text', concat('<span style="white-space:pre">',rpad('abc',25,char(32)), '</span>');

    --
    myDBR Team


Reply

You must log in to post.