Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Separate in three
Message
From
27/08/2005 04:44:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01044481
Message ID:
01044507
Views:
16
Hi,

Why *exactly* three ?

>If there're exactly 3 words in the field than
>SELECT mytable
>SCAN
>  REPLACE ;
>    field1 WITH GETWORDNUM(field123, 1), ;
>    field2 WITH GETWORDNUM(field123, 2), ;
>    field3 WITH GETWORDNUM(field123, 3), ;
>ENDSCAN
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform