Question Filter Replicated data??

[kjoyce]

I've developed a vb.net mobile application that replicates data back to sql server 2005. I now need to program a filter for pulling the replicated data. I can use HOST_NAME() to implement a single parameter filter, for example, RegionCode = '1111'. I can set HOST_NAME() = '1111' and this works when I synchronize the data. My problem is I need to pull multiple RegionCodes and can't figure out how to set this filter. For example, I need to filter RegionCode = '1111' or RegionCode = '2222'. It doesn't work when I set HOST_NAME() = '"1111", "2222"'. Can anyone be of assistance?

 

[cjard]

Host_name() in ('1111', '2222')

?