Substitute of SPACE(N)

You can build that using LPAD.

LPAD('', N, ' ');

Related discussion here.