| Author: Yousuf 29 Nov 2008 | Member Level: Silver | Rating:  Points: 4 |
Update mytable set ext = SELECT REPLACE('abcdefghicde','cde','xxx')
Syntax
REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )
Arguments
'string_expression1'
Is the string expression to be searched. string_expression1 can be of character or binary data.
'string_expression2'
Regards
Yousuf
|
| Author: Sanjay Pal 29 Nov 2008 | Member Level: Silver | Rating: Points: 3 |
REPLACE IS USED FOR REPLACING SOME CHARACTER FROM A STRING WITH ANOTHER STRING
SYNTAX IS AS FOLLOWS:
SELECT REPLACE ('STRING','CHARACTERTOREPLACE','NEWCHARACTERINPLACEOFCHARACTERTOREPLACE')
|
| Author: Gaurav Agrawal 29 Nov 2008 | Member Level: Diamond | Rating: Points: 2 |
use this query i am sure it will done ur work
update tabl set ext=repalce(ext,'''','')
because
select ''''
it returns
'
GA
Thanks & Regards,
Gaurav Agrawal
Sr.Software Engineer
gaur1982@yahoo.com
09829373514
|
| Author: Deepika Haridas 29 Nov 2008 | Member Level: Diamond | Rating: Points: 1 |
you need to write within quotes
update tabl set ext=replace(ext, "'", "");
Regards,
Deepika
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|