(Moderator)
Registriert seit: 9. Dez 2005
Ort: Heilbronn
39.858 Beiträge
Delphi 11 Alexandria
|
AW: SQL ReplaceString
4. Aug 2014, 13:40
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 );
Markus Kinzler
|