|
|
Posted by Hugo Kornelis on 10/02/08 11:44
On 6 Apr 2006 02:32:02 -0700, Shwetabh wrote:
>Thanks Marcus,
>That did the trick.
>
>Now there is one more problem.
>I know to add the string, the query is
>
>UPDATE ace
>SET PICTURE = '\\SHWETABH\Shwetabh\I\' + PICTURE
>
>Now this query appends the string before PICTURE column contents.
>Now is there a way that the contents having the string
>'\\SHWETABH\Shwetabh\I\'
>do not get updated with this string and only cells which do not have
>the string get updated?
Hi Shwetabh,
UPDATE ace
SET PICTURE = '\\SHWETABH\Shwetabh\I\' + PICTURE
WHERE PICTURE NOT LIKE '\\SHWETABH\Shwetabh\I\%'
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|