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.
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
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.