Sheri Hixson
sdhi at kalamazoo.net
Mon Nov 5 14:22:16 CST 2007
I have a column in a table that contains info as shown below: 123 123.456 123 123.456 410 410.435 555 555.123 789 789.678 910 910.321 The first 3 characters are duplicated in 5,6,7. How do I remove the first three characters, and the space, from each record in this column so that the results would be: 123.456 123.456 410.435 555.123 789.678 910.321 Any help would be appreciated! Thanks, Dee