>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 :)

Eric --

I haven't done many SQL Server queries. But, I think there's a CASE construction available. This should work similar to an embedded IIF() function (as distinct from the UDF we came up with above) which is also an approach, though a bit less readable. I'd agree that an in-line statement is the way to go.

Jay