Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Capturing Data
Message
From
15/04/2010 17:18:11
Naomi Nosonovsky
Wisconsin, United States
 
 
To
15/04/2010 17:13:47
Jeffrey Turner
Independent Contractor
Various Locations, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Capturing Data
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01460397
Message ID:
01460403
Views:
60
>How do i capture all the data to the left of the @ sign of an email address?

select substr(Email, 1, at('@',Emal) - 1) as Start from myTable
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform