>>It will work in SQL Server (it strips spaces before determining lenght)but not in VFP.

lcString = SPACE(1)
>>? LEN(lcString)  && Returns 1 but string is empty

>
>That's why I also put LEN(ALLTRIM(lcString)) to be more bullet proof if the string handling might contains some spaces.

It begs the question, why not use EMPTY() function?