[AccessD] Conditional Functions (Switch function)

I use SWITCH() and CHOOSE() quite often.  Regardless of speed, they are so
easy to code and make life a lot easier.  I also like REPLACE() and will
often do multiple lines of REPLACE() each one doing a slightly different job
to get the data as I want it.  They are also easy to understand when
re-viewing past code.

If you are not familiar with these functions, then type in, say, SWITCH()
and position on it and then hit the F1 key for associated help.

Max


On Tue, Nov 25, 2008 at 2:06 PM, Mark A Matte <markamatte at hotmail.com>wrote:

>
> Hello All,
>
> Seeing the question related to 'SWITCH'...made me wonder...
>
> How many 'similar' conditional functions are there...and when is it
> appropriate to use each?
>
> IF
> IIF
> CASE
> SWITCH
>
> I'm sure there are more...and I'm curious to know what they are.
>
> Thanks,
>
> Mark A. Matte
> _________________________________________________________________
> Color coding for safety: Windows Live Hotmail alerts you to suspicious
> email.
>
> http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_safety_112008
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>