I have this query that searches for an string within the description field and would like not to accept an empty entry, is there some code I can put to do this?
Here is the query;
SELECT T0.Comments,T0.DocNum, T0.DocDate, T1.ItemCode, T1.Dscription, T1.Quantity, T1.StockPrice FROM OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry WHERE (T1.Dscription Like '%[%0] %' OR T1.Dscription LIKE '[%0]%' OR T1.Dscription LIKE '%[%0]')