Posted by Shwetabh on 04/05/06 09:36

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

• Next in forum: Re: Transport Level Error has occured
• Prev in forum: Transport Level Error has occured
• Thread view: Reversing string concatenation

[Reply to this message]