rooms.sex='M' or rooms.sex = 'F'

Thats how I distinguish between room sex.

As for you method. I works fine but I am putting this into a stored procudere on a sql server and I think i would have to create seperate stored procs then for your method to work.

Ill definatly consider it if nobody else has any ideas...

Thanks :)