rpad with space not working

(2 posts) (2 voices)


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


You must log in to post.