Carlo Romagnano (8/22/2013)
In this case CONCAT also is faster than ISNULL(FirstName + ' ', '') + ISNULL(MiddleName + ' ', '') + ISNULL(LastName + ' ', '') + ISNULL(CONVERT(VARCHAR(3), Age),'')Because you call ONE function and 4 parameters vs 4 functions with 8 parameters and ONE CAST.
That's why i love it. :-):-):-)
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!