To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
SQL CourseSQL Course
> Ask questions about the lessons on SQL Course 1 and 2. If you have problems
> with the interface, please post in the Feedback forum
I have a field that has a 9 digit number in it. I want to extract this number but I need to truncate the first 4 digits of it so on my output I have a 5 digit number. How do I do this in SQL on a FoxPro database? Thanks.