Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select, Update & partial string replacement
Message
From
30/08/2001 05:59:01
Doug Johnston
Megamotza P/L
Mornington, Australia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select, Update & partial string replacement
Miscellaneous
Thread ID:
00550743
Message ID:
00550743
Views:
59
Hi,

I have a Paradox sales.db file accessed via ODBC where I need to change all the first 4 characters of the sales.idnum which is a PK field. I would rather use SQL as in the past this has proved faster than loading a remote view, doing a string replacement and updating the view.

The scenario is as below...

Original sales.idnum
S0991231
S0991232
S0991233
S0991234

Need to be changed to...
A0011231
A0011232
A0011233
A0011234

I guess what I am looking for is an SQL equivelant to...
UPDATE ALL sales.idnum WITH 'A001'+SUBSTR(sales.idnum,5,4)

Regards
Doug Johnston
Next
Reply
Map
View

Click here to load this message in the networking platform