I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE" I will see the substituted value "999994" Unfortunately I'm getting syntax error. thank you.
SQL Script sample:
SELECT DISTINCTROW IIf([sub2group]='RSAMSTORE','999994',IIf([sub2group]='RNEWSTORE','999995',
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!