SELECTING SPECIFIC RECORDS IN A COLUMN ELSE ALL OF THEM

Kate Smith

Total Post:24

Points:168
Posted by  Kate Smith
C# 
C#
 981  View(s)
Ratings:
Rate this:

I am building a website in ASP.NET with SQL Server 2012 use in back end.

And I also have drop down boxes that contain the following strings as an example.

<asp:ListItem>abc</asp:ListItem>

<asp:ListItem>zyz</asp:ListItem>

<asp:ListItem>dood</asp:ListItem>               

<asp:ListItem>foo</asp:ListItem>

What sort of SQL command do I need to in order to be able to use logic like this pseduo.

If SelectedItem is 'abc' return all rows in column

ELSE IF

Retrieve records in column where alphabet_text = ListItem.

I dont want to use a simple IF ELSE stored procedure because I have lots and lots of filtering options available and making else seems really badly designed.

  1. Andrew Deniel

    Post:29

    Points:203
    Re: Selecting specific records in a column else all of them

    Use WHERE with OR:

    SELECT IdCol, TextCol

    FROM dbo.Table

    WHERE @TextCol = 'Doesnt matter' OR TextCol = @TextCol

    On this way TextCol will only be evaluated if the paramater is different than Doesn't matter.

    Note that i've used the text value just for demontsration purposes. You should use the IdCol instead since(text can change anyway).

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!