General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only