Bebeu

Strange, because your request look good. Here is mine : select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Name like "%PAR" give me all Workstations from Paris.... If you look in table SMS_R_SYSTEM with sql management studio , is it ok ?