Question Locked
String manipulation
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.