Home Forums SQL Server 7,2000 T-SQL Maximum Number of "When Then" lines in a CASE statement? RE: Maximum Number of "When Then" lines in a CASE statement?

  • November 21, 2013 at 2:07 pm

    #1668247

    terrencepierce (11/21/2013)

    Hey, I appreciate the test. I have a list of thousands of entries (people have a habit of typing the same thing very different ways) that I need to examine and then categorize. Initially I was looking at a monster CASE using LIKE to collapse the list. I guess it depends how much commonality there is to be found.:-D

    yeah definitely sounds like using a lookup table would be better;

    then you can join on the "WHEN" entry value to the lookup table, and get the translated "THEN" value from the table.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!