FoxPro Space() Function

Question

I have this:

select keyfld, plrevno, space(2) as AAA, ;
    plandt, plan_enddt ;
    from d:\oct_2018_data\DBFS\plan ;

What is the space(2) part doing? Is it taking the first 2 characters of the plrevno column?

Answer 1

The space() function returns a string consisting of n spaces, where n is the value passed to the function.

In this case, it's creating an empty field, 2 characters in length, in the query.