Richard
Wed Apr 04 14:08:26 CDT 2007
James Smith wrote:
> I'm trying to run an adsi query to output a list of all of our
> contractors.
> We designate our contractors by the display name being capitalized. Is
> there
> a way in say the "objCommand.CommandText =" to specify a displayName
> filter
> be capitalized?
No. ADO queries are case insensitive. You would need to retrieve all users
and their displayNames, enumerate them, then see which have displayNames
with all capitals. Can you find some other way to designate contractors? A
query can use the wildcard character "*" when filtering on displayName, for
example. Or you could assign a value to some other unused attribute, like
employeeID.
--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab -
http://www.rlmueller.net
--