• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 90
  • Last Modified:

Like Query in Access and SQL Server Context

I wrote two LDAP Queries one for USERS and one for PCS. CN=NPP\, Training9,OU=000Generic Accounts,OU=NAZ,OU=User Accounts,DC=one,DC=ads,DC=che,DC=org is a Example of one Column where LDAP Context exists What I want to do is Filter through these records and just grab all the records that have OU=NAZ in the column called LDAP.

mY ACCESS QUERY IS
SELECT *
FROM [Global]
WHERE (((Global.[LDAP]) Like '%OU=NAZ%'))
ORDER BY Global.Lastname
That displays 0 Records but no errors. Can someone tell me correct syntax for MS Access and MS SQL.
I WOULD REALLY APPRECIATE THIS AND THIS WOULD SIMPLY ALOT OF MY WORK.
0
powerztom
Asked:
powerztom
1 Solution
 
Rey Obrero (Capricorn1)Commented:
Use * instead of % in Access


 SELECT *
 FROM [Global]
 WHERE (((Global.[LDAP]) Like '*OU=NAZ*'))
 ORDER BY Global.Lastname
0
 
powerztomAuthor Commented:
Rey thank you so much for your Help. I'm Happy.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now