Or operator does not bring back data as expected in SQL Server 2000.
Posted on 2007-03-28
The query I have is supposed to return data greater than 30 characters in all fields queried against.
The first field displays the data greater than 30 characters, but the other fields display data greater than 30 or less than 30. The query does not work.
Here is the query:
where (Len(regline1)> 30 or (Len(regline2)> 30) and (Len(regline3)> 30)) or (Len(regline4)> 30) or (Len(regline5)>30) or (Len(regline6)>30)))