DataAssist Search to Test that a column contains a value
I am trying to add a search parameter to search a column that contains URLs. I want the user to be able to either select a checkbox or maybe a yes/no dropdown to find results if a field contains a value or not. It doesn't need to match the value...only show results that contain a value. I tried using the "Check" type but it is saying that the recordset must match a NULL or "" entry and I would get an error if it tried to match anything else. Of course, I did get a SQL error. So would the strategy be to add a recordset column that already had the logic of that URL column set to either Yes or No?