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.
Printable View
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.