Cacher is the code snippet organizer for pro developers

SELECT 

CASE 
WHEN WVTProduct.standardAmount = 'test'
               THEN '0' 
               ELSE '1'
			   END AS FieldName,
*
FROM Table_Name