Microsoft Access – Case Query

by

There is no CASE … WHEN in Access SQL. You can use the Switch Function instead.

UPDATE HAI
SET REGION = Switch(
    NUMREG Like '*1', 'BDG',
    NUMREG Like '*2', 'JKT',
    NUMREG Like '*3', 'KNG'
    );

That query uses Access’ default (ANSI 89 mode) * instead of % wildcard character. If you want to use the % wildcard, you can do it with the ALike comparison operator.

UPDATE HAI
SET REGION = Switch(
    NUMREG ALike '%1', 'BDG',
    NUMREG ALike '%2', 'JKT',
    NUMREG ALike '%3', 'KNG'
    );

More Related Contents:

  1. sql in ms-access [closed]
  2. Managing and debugging SQL queries in MS Access
  3. Upserting in MS-access
  4. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  5. How do I write a full outer join query in access
  6. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  7. How to simulate UNPIVOT in Access?
  8. Table-less UNION query in MS Access (Jet/ACE)
  9. SQL Query – Using Order By in UNION
  10. Ms Access Query: Concatenating Rows through a query
  11. Date Difference between consecutive rows
  12. Top n records per group sql in access
  13. Access-SQL: Inner Join with multiple tables
  14. Address standardization within a database
  15. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  16. How do I implement pagination in SQL for MS Access?
  17. SQL to add column with default value – Access 2003
  18. Achieving ROW_NUMBER / PARTITION BY in MS Access
  19. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  20. SQL Updating from an inner join
  21. Lightweight SQL database which doesn’t require installation [closed]
  22. Convert String to Date in MS Access Query
  23. HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
  24. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  25. How do I perform update query with subquery in Access?
  26. SQL Update woes in MS Access – Operation must use an updateable query
  27. SQL SET DEFAULT not working in MS Access
  28. How do I create a decimal field in Access with Alter Table?
  29. Access substitute for EXCEPT clause
  30. Escaping ‘ in Access SQL

Leave a Comment