Patrick - not sure in anyone covered this yet -
but -
you can also do ..
select rtrim(isnull(firstname, ' ')) + rtrim(lastname)
here -
but -
the one space just put in will be trimmed, as well ..
something to think about - hth -
mondo regards [Bill]
>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?