Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to compare two fields within a table.
example:
Bring field only when X equals Y
That is doable.
if(Fieldx =FieldY, Field C) as Field C
this will only load Field C if X =Y.
If they don't equal, the value will be null.
That is doable.
if(Fieldx =FieldY, Field C) as Field C
this will only load Field C if X =Y.
If they don't equal, the value will be null.
hi,
BirthAddress:
LOAD
BirthAddress
Resident
UserAddress
Where BirthAddress=PresentAddress;
not sure is this your requirement.
Thanks, it really worked