Stored Procedure

[Shwetabh]

Hi,

I want to change the data in a few fields of a table.
There are many records (about 1k+). All I want to do to
these fields is to append a string to the starting of data in the
fields.
eg:

Old Data ->

---------------------------
Image
---------------------------
A1.jpg
A2.jpg

Required data ->
-----------------------------
Image
----------------------------
\Images\A1.jpg
\Images\A2.jpg

For this purpose, should I use a procedure or is there any other
possible way out?

Awaiting your replies,
Regards
Shwetabh

[Dan Guzman]

Try:

UPDATE MyTable
SET ImagePath = '\Images\' + ImagePath

This can be encapsulated in a stored procedure if needed:

CREATE PROC dbo.UpdateImagePath
@ImagePathPrefix varchar(255)
AS
UPDATE MyTable
SET ImagePath = @ImagePathPrefix + ImagePath
GO

EXEC dbo.UpdateImagePath '\Images\'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Shwetabh" <sh**********@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

Hi,

I want to change the data in a few fields of a table.
There are many records (about 1k+). All I want to do to
these fields is to append a string to the starting of data in the
fields.
eg:

Old Data ->

---------------------------
Image
---------------------------
A1.jpg
A2.jpg

Required data ->
-----------------------------
Image
----------------------------
\Images\A1.jpg
\Images\A2.jpg

For this purpose, should I use a procedure or is there any other
possible way out?

Awaiting your replies,
Regards
Shwetabh

[Shwetabh]

Thanks a million Dan, it works like a charm!