Also what error was that previous query giving?
On Tue, 17 Aug 2004 16:24:48 -0400, Chunshen (Don) Li
<[EMAIL PROTECTED]> wrote:
> I'd recommend you run some query first to make sure you really don't have some rows that exceeds 8000 bytes like
> SELECT Len(productDescCol)
> FROM thisTBL
> WHERE productDesc = Max(productDesc)
>
> Then, go to Enterprise Manager (oops, did you say you're using MS SQL Server?, otherwise, its equivalent, go to table, design, change the data type there, you would receive warning, ignore it.
>
> On UpdateText() function, too "messy" ihmo.
>
> >How do I change the datatype? And will I lose any data when I change the
> >data type?
> >
> >Thank you,
> >
> >Donna French
> >
> >
> >
> >-----Original Message-----
> >From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, August 17, 2004 1:15 PM
> >To: CF-Talk
> >Subject: Re: Add text to end of text field?
> >
> >Unfortunately, the following Update query won't work, however, it would
> >if the column is of data type, char/nchar, varchar/nvarchar. Why not
> >change the data type to varchar(8000), should it be plenty for product
> >description?
> >
> > _____
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
