Re: UPDATETEXT

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: simon (simon.zupan_at_stud-moderna.si)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 12:43:12 +0200

Hi,

if I replace first null with 0 then I lost old value, the new value
overrides the old value, the result is:

';new text'

Thank you,
Simon

"Ibrahim Shameeque" <IbrahimShameeque@discussions.microsoft.com> wrote in
message news:077915EC-3B62-42F2-BE04-C5BA3C9C8E2E@microsoft.com...
> Hi
> Give an insert_offset value. starting from 0 for inserting to the begining
of the text data. In your update statement, replace the first null with 0.
Thanks
> --
> Ibrahim
>
>
>
> "simon" wrote:
>
> >
> > Declare @oldValue varbinary(16)
> > Declare @str varchar(8000)
> >
> > Select @oldValue =TextPtr(description) From t_narocilnica where ID=1
> >
> > set @str=';new text'
> >
> > UPDATETEXT t_narocilnica.description @oldValue NULL NULL @str
> >
> > Thiss appends the new text to the old description at the end of the
text.
> >
> > If I had old description:
> >
> > 'old text'
> >
> > than I have now: 'old text;new text'
> >
> > It always append to the end of the text.
> > How can I append the new text to the begining, I would like that my
result
> > is:
> > 'new text;old text'
> >
> > Thank you,
> > Simon
> >
> >
> >
> >

Relevant Pages

  • Append Query
    ... My Brain is fried and I lost my book... ... which includes other fields but I need to append ...
    (microsoft.public.access.queries)
  • RE: UPDATETEXT
    ... starting from 0 for inserting to the begining of the text data. ... In your update statement, replace the first null with 0. ... > UPDATETEXT t_narocilnica.description @oldValue NULL NULL @str ... > It always append to the end of the text. ...
    (microsoft.public.sqlserver.programming)
  • Re: group- ?
    ... > lost several of my groups. ... > append, it replaces. ... But at least you probably could have restored by copying back the relevant ... To UNSUBSCRIBE, email to debian-user-request@lists.debian.org ...
    (Debian-User)
  • Re: putting > in reply messages?
    ... Gaikokujin Kyofusho wrote: ... > seem to figure out how to make it append '>' to the begining of each ... Brian Tillman ...
    (microsoft.public.outlook.general)
  • Re: fopen and r+ problem
    ... s1m0n wrote: ... I would like to write a simple code to add some text at the begining of ... a file without erase the other data. ... Use append instead, 'a', this will add new lines to the bottom instead of at ...
    (alt.php)