* If ThisForm.Customer is numeric/integer (ThisForm.Customer = 0 or Ordhead.customerid = ThisForm.Customer) * If ThisForm.Customer is character (nn is the size of Ordhead.customerid field) (ThisForm.Customer == SPACE(nn) or Ordhead.customerid = ThisForm.Customer)>In a SQL select statement. (original code VFP 5) I came across the code below as part of the WHERE clause
>(Empty(?ThisForm.Customer) or ?ThisForm.Customer= Ordhead.customerid) >>