Think this would have been a better question if it had been multiple checkboxes.

Kind of like

+ is a

A. Addition Operator

B. Concatenation Operator

C. Mathematical Symbol

D. The fifth letter of the...

Well W3 considers it an operator.

http://www.w3schools.com/sql/sql_in.asp

But I could also see the case that you have an IN clause with the IN operator and the results of that clause are the...

Lynn Pettis (1/4/2010)

---

A true master knows when they know less than others think they know.

The trick is knowing where and how to find the answers to the questions where your...

Sorry,

I have to agree with Lynn.

If you don't have a table named employees, then of course it won't work.

Copying and pasting the query code into SSMS and running it is...

Actually came up with something that worked quite well.

I created a view off of the measures table that just excluded the 0 values. And then brought that in as...

Rob Goddard (11/19/2009)

---

😀

OK, that's my fault again. You did mention that one and I didn't add it to the...

It's going into a web based drop down combo/list box for users to select the version of software that...

So far so good... except the CNXN doesn't work still.

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value 'CNXN' to data type int.

Originally I wrote...

Hey Rob,

That actually works awesomely for 858/860 of my records in production.

I didn't realize how bad this data was until I found two records it doesn't work on. (I tested...

bc_ (11/18/2009)

---

Not sure I follow, but what if you got rid of the @'s for sorting:

select

*, REPLACE(REPLACE(versionval, '@', ''), '@@', ''), CASE CHARINDEX('.', REPLACE(REPLACE(versionval, '@', ''), '@@', ''))

WHEN 0...

No... it's not a character comparison... as I said, my query attempt is only semi-working at this point.

Whatever...

Even in a batch... the odds are about 50/50 that I'll get different results for the...

Lynn Pettis (11/17/2009)

---

Okay, I give up. No one is really paying attention to the concept that the question was trying to bring out. Everyone is concentrating on the...

Yes, but there are two flaws...

The question only goes down to...