Topic: (case when xyz = 1 then 'A' else 'B' end) ???
(case when xyz = 1 then 'A' else 'B' end)
=> how can i change the condition "1" to the condition "(text-)field is empty", then 'A'... if "not empty" then 'B'
My Visual Database → General → (case when xyz = 1 then 'A' else 'B' end) ???
(case when xyz = 1 then 'A' else 'B' end)
=> how can i change the condition "1" to the condition "(text-)field is empty", then 'A'... if "not empty" then 'B'
here is a very easy way
Hi Both,
Another option is to use a calculated field (please see the attached for the syntax).
Derek.
second example
My Visual Database → General → (case when xyz = 1 then 'A' else 'B' end) ???
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi