>Hi everybody,
>
>I wrote the following SP (thanks for Mike Levy for advice to create 3 different SPs instead of one complicated). Note defendant field formatting. My question is: what is the correct and best way: do formatting inside SQL Server or do it in ASP, therefore return Def1LName and Def1FName?
============
Ok, after I discussed this problem with Sergey, I think, the simplest thing would be to return both names to ASP and let ASP to do formatting as needed.
Thanks.
If it's not broken, fix it until it is.
My Blog