Sorting Contacts Question

I have changed the sorting of contacts from the CRM-Standard, First Name
Last Name to the following;

Last Name, First Name

Question - Is there any way to automatically apply this type of change for
all existing contacts? I know it states that it will apply the cahnge for
all contacts moving forward, but that seems incredibly confusing for an end
use to have to look at a combination of the two sortings...

Thanks in advance,

Dave
Thu Nov 01 13:59:21 PDT 2007

really the only viable way to do it is using a sql update, which is
officially unsupported. So I am in no way recommending doing this.

unofficially you could try this sql but please backup your database first:

run this query first to see if you like the results of the NewFullName
field:
select lastname, firstname, fullname as OldFullName, isnull(lastname,'') +
', ' + isnull(firstname,'') as NewFullName from ContactBase

if you are 100% satisfied with results, then you can use this sql update:
update contactbase set fullname=isnull(lastname,'') + ', ' +
isnull(firstname,'')

Dave Ireland


"CPW" <wrightcp@comcast.net> wrote in message
news:%23m5iCoLHIHA.2268@TK2MSFTNGP02.phx.gbl...
>I have changed the sorting of contacts from the CRM-Standard, First Name
>Last Name to the following;
>
> Last Name, First Name
>
> Question - Is there any way to automatically apply this type of change for
> all existing contacts? I know it states that it will apply the cahnge for
> all contacts moving forward, but that seems incredibly confusing for an
> end use to have to look at a combination of the two sortings...
>
> Thanks in advance,
>

CPW
Thu Nov 01 14:14:26 PDT 2007

Thanks! This is a demo system - so it should not be an issue


"Dave Ireland" <direland@salentica.com> wrote in message
news:O2hZUoMHIHA.284@TK2MSFTNGP02.phx.gbl...
> really the only viable way to do it is using a sql update, which is
> officially unsupported. So I am in no way recommending doing this.
>
> unofficially you could try this sql but please backup your database first:
>
> run this query first to see if you like the results of the NewFullName
> field:
> select lastname, firstname, fullname as OldFullName, isnull(lastname,'') +
> ', ' + isnull(firstname,'') as NewFullName from ContactBase
>
> if you are 100% satisfied with results, then you can use this sql update:
> update contactbase set fullname=isnull(lastname,'') + ', ' +
> isnull(firstname,'')
>
> Dave Ireland
>
>
> "CPW" <wrightcp@comcast.net> wrote in message
> news:%23m5iCoLHIHA.2268@TK2MSFTNGP02.phx.gbl...
>>I have changed the sorting of contacts from the CRM-Standard, First Name
>>Last Name to the following;
>>
>> Last Name, First Name
>>
>> Question - Is there any way to automatically apply this type of change
>> for all existing contacts? I know it states that it will apply the
>> cahnge for all contacts moving forward, but that seems incredibly
>> confusing for an end use to have to look at a combination of the two
>> sortings...
>>
>> Thanks in advance,
>>
>
>