Hello Everyone,



I have developed a department bases message system where users can multi

select the destination departments in a dropdown list. This of course adds

the data to the field as "xxxxx,xxxxxx,xxx" I also have an option called

"ALL". 



The messages are popped onto a announcement page where the page checks what

dept they belong to and "supposedly" only shows them those messages selected

for their dept or ALL.



I approached it like this:



 if (RS("dest") = dept) or (Rs("dest") = "All") then



which is fine only if one dept is selected 80(



I thought about using a LIKE in the SQL select, but how do i include the ALL

possibility??



any/all help gratefully accepted.



Cheers.



Simon Newton 

Administrator 

Web Services 

Hervey Bay City Council 



Phone: 07 4197 4564 

Web site: www.herveybay.qld.gov.au