"news.microsoft.com" <Keene.scou***@gmail.com> wrote in message
news:O5ZJIQnEGHA.648@TK2MSFTNGP14.phx.gbl...
> How can I strip or replace values in a an image column, for example, if I
> select the data in an image col that returns the following
>
> x25005000440046002D00...
>
> how can I strip out all the '00's to end up with
>
> 0x255044462D
>
> any help would be great.
>
> Bri
>

"Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message
news:ukhLvinEGHA.1032@TK2MSFTNGP11.phx.gbl...
> Start with this script:
>
> http://www.nigelrivett.net/ReplaceText.html
>
> And modify it appropriately -- the same functions it uses should work with
> IMAGE columns as well as TEXT/NTEXT that this script was written for.
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
>
> "news.microsoft.com" <Keene.scou***@gmail.com> wrote in message
> news:O5ZJIQnEGHA.648@TK2MSFTNGP14.phx.gbl...
>> How can I strip or replace values in a an image column, for example, if I
>> select the data in an image col that returns the following
>>
>> x25005000440046002D00...
>>
>> how can I strip out all the '00's to end up with
>>
>> 0x255044462D
>>
>> any help would be great.
>>
>> Bri
>>
>
>