>>I don't see extra spaces in QA but they are present when query run through SPT. The query I suggested returns year w/o extra spaces in both cases.
>
>Yes, not with SQLExec() but doing the same in VFP will generate some. I'm looking for SQL syntax that could be used in both.

I doesn't generate extra spaces in VFP8 for me.