RE: UPDATETEXT

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

From: Ibrahim Shameeque (IbrahimShameeque_at_discussions.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 02:35:02 -0700

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

  • 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: UPDATETEXT
    ... if I replace first null with 0 then I lost old value, ... overrides the old value, the result is: ... >> It always append to the end of the text. ... >> How can I append the new text to the begining, ...
    (microsoft.public.sqlserver.programming)
  • 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)
  • putting > in reply messages?
    ... Hi, i just switched over to outlook, works well enough but i can't ... seem to figure out how to make it append '>' to the begining of each ... line of the message i am replying to. ...
    (microsoft.public.outlook.general)