Let's say I have the following:
SELECT RecordID from Products where RecordType = @RecordType and RecordName = @RecordName.
Let's say sometimes a RecordType is specified and sometimes it isn't. So, if @RecordType is null, I don't want that in the where. So, I could do:
If @RecordType is Null SELECT RecordID from Products where RecordName = @RecordName Else SELECT RecordID from Products where RecordType = @RecordType and RecordName = @RecordName
But is there any more elgant way to do this within the original SELECT so that the IF isn't required? I have a lot of these and would prefer not to have to have multiple versions of every select or duplicate procedures.
Note, my RecordType field is never null in the database, but it is not always desired as a criteria for the SELECT