[AccessD] Replace/delete first 4 characters

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

 

 




More information about the AccessD mailing list