Alternative to alt function

[#1]

Hello!

FIELD1 and FIELD2 have not numeric values.

Aternatives?

Alt(Alt(FIELD1, FIELD1B), Value) as FIELD1,

[#2]

Relate:Problem with if expression

[AlexOmetis]

Just to update this old post... there is now the COALESCE function that is like ALT but for strings...