Mike,
In T-SQL you would use ISNULL() function instead of VFP NVL().
UDF's are only available in SQL 2000. See Sql Server Books Online (BOL) for more details.
>Sergey
>
>I have a book called Transact-SQL. I cannot find how to suppress null values in my results like the VFP function NVL(). I also cannot find anything about creating UDFs, but it does cover stored procedures. Would you please explain further?
>
>Thanks!
>
--sb--