Thanks LOWELL,

but unfortunately, it doesn't work... 🙁 it doesn't change the href position in the same row.

I have more than one href in the same row....

Thanks LOWELL !!

I'm going to try right now your solution..... 😀

Thanks for your suggestion!

Alessandro

Thanks Luke,

I really appreciate your help !

😀

Alex

Hi Luke!

I couldn't change the lenght of the table, it must be a TEXT column 'cause as I said this table is populated by a JS that is an online...

Thanks Luke, great solution!!

when I execute this script, it return an error :crying:

UPDATE HTMLART

SET Body = REPLACE(Body, 'a href="', 'a href="MyPath/')

WHERE ID = 1

Server: Msg 8116, Level 16,...

Thanks Luke,

this is very interesting solution. The problem is that I don't have the plain control of what I'm going to insert in the body column. I'm going...

excuse me.... how can I post you the insert statement? I don't know why but when I try to post the line with HTML tags... the form transform the statement......

Thanks for you prompt answer !!!

What I'm try to do is a SP or UDF to change the insert of one line in the table by using the CHARINDEX...

SOLVED BY RYAN !!

Thank's a lot !!

rossetto_ax (4/21/2008)

---

RyanRandall (4/21/2008)

---

Another option and my preference is...

DECLARE @Rows TABLE (RowNumber INT IDENTITY(1, 1), Col1 VARCHAR(10))

INSERT @Rows SELECT 'B' UNION ALL SELECT 'A' UNION ALL SELECT 'D'

SELECT a.Col1, a.[Val 1]

FROM...

RyanRandall (4/21/2008)

---

Another option and my preference is...

DECLARE @Rows TABLE (RowNumber INT IDENTITY(1, 1), Col1 VARCHAR(10))

INSERT @Rows SELECT 'B' UNION ALL SELECT 'A' UNION ALL SELECT 'D'

SELECT a.Col1, a.[Val 1]

FROM @Table...

Thank's Ryan !!

But unfortunately is not what I need.... I can't order by the value order but what I have to...

Rajesh Patavardhan (11/15/2007)

---

One option is to use the Custom Scripting option.

Not sure whether this is the best way.

Following is a sample script to put in the Code section of report

public...

WOW IT WORKS !!! :Wow:

Thanks !!

the problem was actually the decimal places !! With Decimal(5,2) work fine.

Thanks a lot for your patience. 😉

Alessandro

Yes, this is right but I couldn't modify the table... now I try to round beforre inserting