string variable vs boolean variable

[Ann]

Hi Guys,

Here is my query:

I have a string variable with four values and rendering four crosstabs using it.
Same thing i can implement using four boolean variable checking for respective four values.

Now i want to know which one is a better solution in terms of performance ?

[MFGF]

The string variable will stop evaluating once it finds a True result, so if you code it with the test most likely to succeed at the beginning, it should be more efficient than always evaluating four boolean checks.

Regards,

MF.

[Ann]

Thanks for the input. :)