SELECT PADR("",20) as tmpfld

>Sorry, but SQL statements are not my strong point.
>
>In a SQL Select statement, I need to create an extra field 20 characters long that is not found in the table. I am naming this field TmpFld. I know I use AS TmpField, but didn't know what to AS.
>
>Can someone tell me how to do this?
>
>Thanks....
>
>Mel Cummings