Some sample data and output results would help understand what you are looking for better.

Building on Steve's, try this:

create table dbo.MyTable (roomtype varchar(4), amenity int)

go

create function dbo.RoomTypes(

    @AmenityList varchar(8000) -- varchar(max) -- for SQL Server 2005

)

returns @roomtypes table (roomtype varchar(4))

as

begin

    declare @temprooms table (

       ...

It is adding an escape character so that the original ] in the string is still treated as a character in the string.  If you read BOL and think you'll...

I have been right.  You must always be right, and everyone else is wrong.  Perhaps we should call you Pope Sergiy, as you are definately acting like the Catholic Church;...

And yet you are still wrong.  There is precisely only 1 of you.  I can precisely count the number of apples in the fruit basket on my kitchen table, or...

And the choice of what rounding function to use is a BUSINESS DECISION based on the requirements of the project.

Also, Sergiy, we have proved that using the Banker Round function is valid, and the proof is posted in this thread.  You won't admit it.

Again, thanks to David M. for...

I agree, it is getting ridiculus.  Sergiy's argument is that the Banker Rounding function should never be used.  David M. even coded Sergiy's own test setup and showed it to be...

Sergiy,

I have nothing to admit being wrong about, and you have failed to prove to anyone that using the Bankers Round function is wrong in any and all circumstances.  You...

Sergiy, You know how to end this.  You either come up with a valid proof and support it or admit you were wrong.  There is no shame in admiting ones...

I really like your choice in footwear.

Okay, I stand corrected, both 1/8 and 1/3 are rational numbers as these fractions are represented as a ratio of two integers.  Irrational numbers are real numbers that cannot be representes...

I checked with my co-worker.  We have discussed the standards we are using, and have some rough notes written down, but unfortunately, we have had the opportunity to formalize the...

First, you are wrong.  There are 2 types of numbers: rational and irrational.  Then number 1/8 is a rational number and is represented precisely as 0.125 (and if you want,...

Okay, 2.0 rounded to the nearest integer: round(2.0, 0) = 2.  Did it round up or down?  You could argue either direction.  The fact is it is already rounded.  Take...