General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>How can I create an SQL statement that gets all records of one field value and the true condition of a second field or a not empty of a third field?
Steven
SELECT SomeTbl.* FROM SomeTbl WHERE SomeTbl.field1 = xyz AND ( SomeTbl.field2 = .T. OR !EMPTY(SomeTbl.field3) )
HTH
Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only