Skip to Content
0
Former Member
Mar 03, 2009 at 12:01 PM

Do not accept Null entry in a Query

19 Views

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]')