Question

Locked

String manipulation

By mharris ·
In Access, I have a query that brings up the following: Description
13336-001-00/18811-10368/KGH

The first 12 numbers represent part numbers. I would like to have a query that will search a string until it gets to the first "/", and then gives me all the characters to the left.

For this example, I can just use a Left$ function, but sometimes that field will vary in size. The constant being the "/" in the string.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums