I have data in a column that has numbers letters and characters in, all that I require is the first 9 numbers (these are always the first 9 characters), any idea how this can be achieved.
Many thanks
John
I have data in a column that has numbers letters and characters in, all that I require is the first 9 numbers (these are always the first 9 characters), any idea how this can be achieved.
Many thanks
John
Last edited by johncon; 01-08-2009 at 09:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks