Rich TextBox with Picture and Text

Dear All

I want to create a RichTextBox, and then i want to show picture and Text at a time, suppose

Welcome to MSDN Forum

how can i accompalished this task.

Thanks

You're not really asking a SQL question. What development tool and language are you using to accomplish this? I can move the question to the correct forum based on your answer.

Mike

|||

Sorry for missplaced thread, this problem is already solved, any one interested can refere to following URL

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=667916&SiteID=1

sql

Reversing string concatenation

Hi,

How can I remove a part of string from complete string in SQL?

this is something i want to do:

update ace
set PICTURE = PICTURE - '\\SHWETABH\Shwetabh\I\'

But here ' - ' is not allowed.

How can I remove the string \\SHWETABH\Shwetabh\I\ from the column
PICTURE?

Regards,
ShwetabhTry this
UPDATE ace
SET picture = Replace(Picture,'\\SHWETABH\Shwetabh\I\' , '')

Markus|||Also try

UPDATE ace
SET picture = Substring(Picture,1,charindex('-',Picture,1)-1)

Madhivanan|||Or if you know that the first part of the string is always going to be
'PICTURE' then simply use this:

update ace
set PICTURE = left(PICTURE, 7)|||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?

Shwetabh|||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