Ask Your Question

Revision history [back]

When I used your query as you show I get no records returned too. But if remove the extra spaces in your query, I get properties returned. Must be treating them as values starting with a space.

When I used your query as you show I get no records returned too. But if remove the extra spaces in your query, I get properties returned. Must be treating them as values starting with a space.

(L_UpdateDate=2018-04-11T00:00:00+),(L_Status=|1_0,1_4),(L_City=|BasinCity,BentnCity,Burbank,Connell,Eltopia,Finley,Kennewick,Kiona,Mesa,Pasco,Plymouth,Prosser,Richland,Wallula,WestRichld)