SQL ReplaceString

[Dejan Vu]

Are you sure it worked? It looks as if you replace the contents of your column 'URL' with a string like 'REPLACE ([URL], ".", "")' and I doubt this is what you want.

[danten]

Zitat von Dejan Vu:

Are you sure it worked? It looks as if you replace the contents of your column 'URL' with a string like 'REPLACE ([URL], ".", "")' and I doubt this is what you want.

??????????????????????????

Delphi-Quellcode:

update produkt set URL = replace (URL,'.',''); 
 =>> 
[4.8.2014 12:49:11] Executing Query: 
update produkt set URL = replace (URL,'.','');
[4.8.2014 12:49:11] Token ',' expected, but 'replace' found at line 1, column 38 - Native error: 30222

??????????????????????????

[mkinzler]

Absolute Database doesn't kow of an (string-)REPLACE function

http://www.componentace.com/help/abs...gfunctions.htm

If your're sure, that's only one needle:

update table set URL = substring ( URL,1, pos('.', URL)-1 ) || substring ( URL, pos('.', URL)+1 );