If you need something large, try CLOB
On Tue, 17 Aug 2004 21:05:34 +0100, Adrian Lynch
<[EMAIL PROTECTED]> wrote:
> If the column is TEXT or NTEXT at the moment, can you not use UPDATETEXT()
> for this? Assuming you're on SQL Server.
>
> Ade
>
> -----Original Message-----
> From: Donna French [mailto:[EMAIL PROTECTED]
> Sent: 17 August 2004 20:57
> To: CF-Talk
> Subject: RE: Add text to end of text field?
>
> 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?
>
> >Update tablename
> >Set productDescription = productDescription + 'new text to add'
> >Where productID = #productID#
> >
> >-----Original Message-----
> >From: Donna French [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, August 17, 2004 2:04 PM
> >To: CF-Talk
> >Subject: Add text to end of text field?
> >
> >I need to add a line of text to the end of product description.
> >
> >The db field is ntext
> >
> >CF5/SQL Server
> >
> >
> >
> >Thank you,
> >
> >Donna French
> _____
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
