Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update - sql
Message
From
31/03/1999 14:49:06
 
 
To
30/03/1999 21:21:04
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00203649
Message ID:
00204007
Views:
17
>Hi all
>I am trying to move away from "replace" commands to UPDATE-SQL. But how about memo fields where during a loop, I want to use "Replace additive" (perhaps 1000 values). I would appreciate any help
>tia
>john harriss

John,
How about:

UPDATE table ;
set memofield = alltrim(memofield) + newstring

HTH
Brad
Previous
Reply
Map
View

Click here to load this message in the networking platform