>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.