>>>>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?
>>>
>>>Try:

SELECT PADR(ALLTRIM(charfield), 6) as charfield...

>>
>>FYI, you don't need the ALLTRIM(). PADR will pad the value if shorter or truncate it if longer than the specified length.
>
>But it won't remove any *leading* blanks...

Grumble, grumble, grumble..."Hey! When's that movie start? I'm dry as dog in the desert.":-)