Substitute of SPACE(N)

Hi I am lloking for equivalent of MySQL function
SPACE(N)

You can build that using LPAD.

LPAD('', N, ' ');

Related discussion here.