![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Fri, Nov 14 2014 7:34 AM | Permanent Link |
Mike | Hi,
I would like to have the following field calculated. if salutation_id= 1 then salutation:= "Mister" else salutation:= "Madam"; What is the correct syntax to use the statement as computed field? Kind regards, Mike |
Fri, Nov 14 2014 8:10 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Mike
>I would like to have the following field calculated. > >if salutation_id= 1 then > salutation:= "Mister" >else > salutation:= "Madam"; > > >What is the correct syntax to use the statement as computed field? Being an SF addict I'd recommend just use "ser" that covers both ![]() alternatively IF(salutation_id=1,Mister','Madam') should work Roy Lambert |
Fri, Nov 14 2014 9:03 AM | Permanent Link |
Mike | Hi Roy,
Thank you. That did the trick. Regards, Mike |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |