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.

[Back to original message]