SQL to add space to make the field 20 character long - How ?

[mrchonginhk]

Suppose I have a field in the table called FName.
This field is of length that is 20 char max in data.
So some records are just 10 char, some 12, but max is 20.

I need to run a query so that FName becomes always 20 char long
For data with char less than 20 long, I need to insert number of spaces behind the FName in table so that it makes up to 20 char long in the output query.

What is the SQL to do this ?
For example
If the data is
"12345678901234567"
Then it should become
"12345678901234567 "
ie adding 3 space behind.

I must use SQL and not VB.

Thanks

 

[Joe4]

Left([FName] & "                    ",20)

Note there are twenty spaces between the double quotes.

 

[mrchonginhk]

Thanks a lot. It is a great help.

 

[HiTechCoach]

There is a VBA Function Space() that works great here.

You could use:

 Left([FName] & Space(20),20)

 

[Joe4]

There is a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> Function Space()

Interesting. I can't believe in over 12 years of Access programming I never stumbled upon that.
I guess you learn something new everyday!