I have 40 variables:

Var1 = request.form("hid1")
Var2 = request.form("hid2")
Var3 = request.form("hid3")
Var4 = request.form("hid4")
Var5 = request.form("hid5")
Var6 = request.form("hid6")
Var7 = request.form("hid7")
Var8 = request.form("hid8")
etc... up to Var40


I am placing the values of the Variables into one Variable:

sSums = Var1 & "," & Var2 ......

The only problem is that there will be times when some of the variables will not have a value....


Ex:

Var1 = John
Var2 = ""
Var3 = Larry
Var4 = Bob
Var5 = ""

As you can see Var2 and Var5 are empty.....

I want to remove the empty variables from the ONE variable so it looks like this:

sNums = "John, Larry, Bob"

Rather than
sNums = "John, ,Larry, Bob, "


This is an urgent request