I am trying to use LIKE in a web service qualification, querying the SRD:ServiceRequestDefintion form. Here is what I have:
'TakeSRDOfflineFlag' = "Online" AND ('Category1' LIKE (XPATH(/ROOT/Tier_1)+"%") OR XPATH(/ROOT/Tier_1) = $NULL$) AND ('Category2' LIKE (XPATH(/ROOT/Tier_2)+"%") OR XPATH(/ROOT/Tier_2) = $NULL$) AND ('Category3' LIKE (XPATH(/ROOT/Tier_3)+"%") OR XPATH(/ROOT/Tier_3) = $NULL$) This gives me an error ARERR [9130] Error encountered while executing a Web Service : ERROR (313): Data types are not appropriate for relational operation; ERROR (312): Data types are not appropriate for arithmetic operation; In a set fields qualification the syntax would work. Can anyone tell what's the problem with this qualification? Can I not use LIKE for XPATH elements? Thank You Raido _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"