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