Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a database with a field (sex) consisting of two characters M or F (male and female).
In the load I´d like to change the F to W, -
is it possible to make somtheing like
LOAD [sex],
if ([sex]=F), M) as sexA
Or maybe a better solution??????