Hi,

I want to see a column on my table with different format. For example:

A is a Column with String and
B is a another with String.

I want to add spaces "chr(32)" Column B how many Column Length.

like this. I know I cant multiply characters : Select Length(A) * chr(32) || Column(B) ...



if A 1 character i ll add one space before Column B. if A two length I ll add two spaces.

Oracle have a TRANSLATE Function which translate characters to character. But Access dont Accept this function.

How can i solve this problem?

Thanks for help...

What about:

Len(A) * chr(32) & Column(B)