>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?
SPACE() only accepts one parameter, see the help screen.

You could try some other function:

SELECT RIGHT(SPACE(6)+charfield,6)
or
SELECT LEFT(charfield+SPACE(6),6)
or
SELECT PADL(charfield,6," ")
or
SELECT PADR(charfield,6," ")
or
SELECT PADC(charfield,6," ")

for PADx if you omit the space character, it will default to spaces.