General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>Exactly where I'm heading - but this is a legacy table - I needed the three state recognition in the end...
>>>
>>>>>Hello UT,
>>>>>
>>>>>select * from ster where SubStr(sunum,1,1) = "E" .AND. eclrhse == .F.
>>>>>
>>>>>returns cursor containing "unknown" or "unmarked" records as well.
>>>>>(logical not known yet)
>>>>>How may I return only records containing marked-logical-False?
>>>>
>>>>It may be apparent that using your own data type represented by a character like -- "Y", "N", or "U" would give you the discrimination that you need.
>>>>
>>>> Jay
>>
>>Can you add a logical field to the table to indicate whether or not the data has been entered for this field?
>>
>> Jay
>With ~~ 21K recs I would have-to populate the new field - I would still need a programatic solution to populate the new field
If there is a programmatic solution, then why not use that in your SELECT?
Jay
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