We have a field of manhole labels that consist of "district#-manhole#". I want to truncate the "district#-" and leave only the manhole number.

Example:
7-345 becomes 345 or
12A-17 becomes 17

Any ideas?
Thanks,
SKK

This is just an observation and not the answer I'm afraid. Your table design should probably be set up so that your district # and manhole # are divided into two separate fields which you could then join to make look like, for example 7-345.

Steve,

I agree with DBL.
However, this is what you can do if you want to update your table data:

UPDATE <yourTableName>
SET
<yourTableName>.DistrictManhole=Mid(<yourTableName >.DistrictManhole, Instr(<yourTableName>.DistrictManhole, "-")+1)
;

If you just want to show truncated results, you this:

SELECT Mid(<yourTableName>.DistrictManhole, Instr(<yourTableName>.DistrictManhole, "-")+1)
FROM <yourTableName>;

Suc6,

RV

Thanks for your comments. Your suggestion of splitting the field up is exactly what I had in mind. This database is left over from years ago.

Thanks again,
SKK