Hi I am lloking for equivalent of MySQL function SPACE(N)
SPACE(N
You can build that using LPAD.
LPAD('', N, ' ');
Related discussion here.