Hi everybody!

1 - I am searching for something in SqlServer that is similar to IIF in the Fox syntax. I need to retrieve a string via SqlExec from Sql-Server where one field should be composed by RTRIM(firstname)+RTRIM(Lastname) and in between a space "IIF" firstname is empty.

2 - By the way: is there anybody who know can tell me where to find an overview of fox-Functions and how to realize them within SQL server?