select samaccountname, sn, givenname, displayname, physicaldeliveryofficeName, mail, TelephoneNumber, Department from 'LDAP://DC=YourSubdomain, dc=YourDomain, dc=yourdomainext' Where ObjectCategory='person' and  objectClass='user'

 

and sQl Database that i am attaching to with a Field Called CostCenter of integer.

 

I want to link the CostCenter Field with the PhysicalDeliveryofficeName which is string. 

 

So here is the Question:  Can I Change the data type of PhysicalDeliveryofficeName to integer in the ldap Query so that it can be linked with the sql table.

 

I kow the answer is change the sql field to string but that changes other things we are doing so not an option.  Another would be to import that into another database and change it but i was looking for a command that might work for me like convert.

 

thanks in advance for any suggestions.

 

thanks

 

mark