Change a field

Hi,

Is there a way to change a nvarchar into a picklists without having to
delete the current field ?

Thank You in advanced

Patrick
Thu Feb 09 10:24:30 CST 2006

For system field there is no way. Custom fields you can delete and recreate
but that is about it.

"M Hendra" wrote:

> Hi,
>
> Is there a way to change a nvarchar into a picklists without having to
> delete the current field ?
>
> Thank You in advanced

MHendra
Thu Feb 09 11:20:32 CST 2006

If the nvarchar already created and and there are values in there, how could
I migrate the values into the newly created picklist ?

We tried to DTS the value, but the picklist saves int value instead of the
varchar value.

Thanks.

"Patrick" wrote:

> For system field there is no way. Custom fields you can delete and recreate
> but that is about it.
>
> "M Hendra" wrote:
>
> > Hi,
> >
> > Is there a way to change a nvarchar into a picklists without having to
> > delete the current field ?
> >
> > Thank You in advanced

Peter
Sat Feb 11 21:51:49 CST 2006

Create a new field ( picklist ) and the write a little external program to
migrate

Pete


"M Hendra" <MHendra@discussions.microsoft.com> wrote in message
news:435046C8-06A6-45EA-87EC-2B98356CBBCE@microsoft.com...
> If the nvarchar already created and and there are values in there, how
> could
> I migrate the values into the newly created picklist ?
>
> We tried to DTS the value, but the picklist saves int value instead of the
> varchar value.
>
> Thanks.
>
> "Patrick" wrote:
>
>> For system field there is no way. Custom fields you can delete and
>> recreate
>> but that is about it.
>>
>> "M Hendra" wrote:
>>
>> > Hi,
>> >
>> > Is there a way to change a nvarchar into a picklists without having to
>> > delete the current field ?
>> >
>> > Thank You in advanced