This is an old revision of the document!

Table of Contents

These are the possible status codes
- frog
- notfrog

Test3 status query

SELECT 
    IIF (LOWER(common_name) LIKE '%frog%', 'frog', 'notfrog') AS STATUS,
    scientific_name AS RESULT
FROM species
LIMIT 1;

These are the possible status codes

frog

<div style="background-color: #F8CECC">In debt: :result</div>

notfrog

<div style="background-color: #D5E8D4">All okay: :result</div>

dbquery/test3.1756297279.txt.gz · Last modified: 2025/08/27 12:21 by Richard White