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 ?