>>>I once saw a download of VFP style functions for SQL Server. Can someone point to where I can find it again?
>>>
>>>thanks
>>
>>Brad Schulz has a blog post
>>
>>Handy String Functions
>>
>>You can also find a good Proper function here
>>
>>Proper Function
>
>Thanks.
>
>I may be in need these sometime in the future (hope not)
>
>But...
>
>First, The LessThenDot URL resulted in a 404 Not Found error -- Please resend
>
>Second, one function I could use is a IIF() function that accepts a varient arguments and returns a varient.

There is no IIF, you need to use
CASE WHEN SomeLogicalExpression THEN SomeValue WHEN AnotherLogicalExpression THEN AnotherValue ELSE ElseValue END

For the Proper function the link is

http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/sql-server-proper-case-function