|
|
Posted by Ed Murphy on 04/25/07 16:28
BillCo wrote:
> I have a procedure that I use to return data based on optional
> parameters. It works fine, except when the underlying data contains a
> null on one if the fields being searched.
>
> My system uses a default wildcard for all parameters, so this excludes
> such records. I need a way to add in " OR fldName IS NULL " where the
> parameter is empty or '%'. I've looked at using CASE WHEN, but it
> doesnt seem to like SQL Keywords being part of the WHEN clause.
Try this:
WHERE COALESCE(tblUnits.strUnitID,'') LIKE @strUnitID
etc.
Navigation:
[Reply to this message]
|