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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums