Posted by figital on 03/01/06 16:34

Using the function might be useful for consistency. I have worked in
databases where we have identical code all over the place: e.g.
LastName + ', ' + FirstName + ' ' + MiddleName.

I function would be nice for that. As far as speed goes, It may have a
negative effect.

Another option is to create a view of your data that has a FullName
column based on the others.

• Next in forum: Re: Insert first n columns from select
• Prev in forum: Re: restore sql 7db to sql2000
• Thread view: Re: Reasonable to assemble FullName W/ A UDF

[Reply to this message]