String manipulation

By mharris ·
In Access, I have a query that brings up the following: Description

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.

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

All Answers

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums