Substitute of SPACE(N)

[hanson]

You can build that using LPAD.

LPAD('', N, ' ');

Related discussion here.

Function REPEAT(string, number)

Okay , I know how to implement it