Post reply

Stores Procedure with Conditions based on a parameter

  • November 2, 2010 at 10:38 am

    #1245534

    WHERE ColumnA LIKE

    CASE

    WHEN @Type = 'TWO' THEN N'%' + N' 20-' + N'%'

    ELSE N'%' + N' [3-4]0-' + N'%'

    END

  • November 2, 2010 at 2:32 pm

    #1245737

    Thanks so much!

  • November 3, 2010 at 10:51 pm

    #1246377

    How do I say something equivalent to

    .....

    WHERE

    ColumnA LIKE

    CASE

    WHEN @Type = 'TWO' THEN N'%' + ' 20-' + N'%'

    WHEN @Type = 'THREE_FOUR' THEN N'%' + N' [3-4]0-' + N'%'

    WHEN @Type = 'OTHER' THEN ....NOT (N'%' + ' 20-' + N'%') OR (N'%' + N' [3-4]0-' + N'%')

    (ie: all others except those defined by the previous two parameters)

    END

    Any assistance most appreciated.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply