Edgar,

As George pointed out, you need PADR() or PADL().

SPACE(x) makes a string x space-characters long.



>I can’t get this right.
>I want to SELECT and at the same time make the field longer.
>Let say the field is 1 char long. I want to select it into my updateable cursor and make it 6 char long
>
>SELECT charfield FROM Cursor && will give me just the one char long as it is, so I tried:
>SELECT SPACE(charfield,6) FROM Cursor && and lots of other variations and I can’t get it to work
>There has to be a way to do this!
>Suggestions?