Need help!

[Stacy]

I have a query looking at 3 tables that I am trying to pull user access
responsibility names out of. However, I have criteria for the name
structures that it has to match:

Not Alike "ABCD FR%"
Not Alike "ABCD MCR%"
Not Alike "ABCD MST%"
Alike "ABCD%"

Unfortunately, I can't change these naming structures, and I have to look at
it from a country code aspect, but the US doesn't have the country code
designation. It's just plain ABCD....

Any thoughts? The database, and some of the underlying queries are bouncing
off of an Oracle database by way of an ODBC Connection.

 

[Bob Barrows [MVP]]

I have a query looking at 3 tables that I am trying to pull user
access responsibility names out of. However, I have criteria for the
name structures that it has to match:

Not Alike "ABCD FR%"
Not Alike "ABCD MCR%"
Not Alike "ABCD MST%"
Alike "ABCD%"

Unfortunately, I can't change these naming structures, and I have to
look at it from a country code aspect, but the US doesn't have the
country code designation. It's just plain ABCD....

Any thoughts? The database, and some of the underlying queries are
bouncing off of an Oracle database by way of an ODBC Connection.

I'm sorry, could you go into a little further detail? Perhaps show a few
rows of sample data followed by the rows of desired results from that
sample data?

 

[Stacy]

Here's what I have from looking at a different country responsibility set:

RESULTS FROM MST:
CID #1 Resp Name #2 Resp Name
19 6 ABCD MST Disbursements 7 ABCD MST Disbursements
19 6 ABCD MST Disbursements 7 ABCD MST Disbursements
19 6 ABCD MST Disbursements 7 ABCD MST Disbursements

RESULTS FROM MCR:
CID #1 Resp Name #2 Resp Name
19 6 ABCD MCR Disbursements 7 ABCD MCR Disbursements
19 6 ABCD MCR Disbursements 7 ABCD MCR Disbursements
19 6 ABCD MCR Disbursements 7 ABCD MCR Disbursements

RESULTS FROM FR:
CID #1 Resp Name #2 Resp Name
19 6 ABCD FR Disbursements 7 ABCD FR Disbursements
19 6 ABCD FR Disbursements 7 ABCD FR Disbursements
19 6 ABCD FR Disbursements 7 ABCD FR Disbursements

Here's what I need to see:
CID #1 Resp Name #2 Resp Name
19 6 ABCD Disbursements 7 ABCD Disbursements
19 6 ABCD Disbursements 7 ABCD Disbursements
19 6 ABCD Disbursements 7 ABCD Disbursements

Make more sense?

 

[Bob Barrows [MVP]]

Is "RESULTS FROM MST" a table name?

I'm still not following. Are you saying you want to change "ABCD XXX
Disbursements" to "ABCD Disbursements" in the result?

 

[Stacy]

No. Unfortunately, I don't have a better way to explain this, and this
happens to be one those things you have to be right next to to understand
clearly. I found a longer way to get what I needed.

Thanks.