>Is there any function similar to empty() for SQLSEVER 2008 ?
>Could you suggest any link – reference describing the similarities – differences between VFP and MSSQL sql syntax?

The LEN() function ignores trailing spaces. For character data types

LEN(SomeCharacterColumn) = 0

There's relevant topic at http://fox.wikis.com but site's down at the moment.