LaRetta Posted November 8, 2002 Posted November 8, 2002 I need to identify all text in a field that begins with OCP For instance, OCP3, OCP14 etc for a replace Case(PGM=OCP ?? how do I specific anything after the OCP?
CobaltSky Posted November 8, 2002 Posted November 8, 2002 Try: Case(Left(PGM, 3) = "OCP", 'YourResult')
Recommended Posts
This topic is 8121 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now