From: Mario Camou Date: 2009-11-01T06:17:15+09:00 Subject: Re: how can i perform a one line case statement on a number --0016e6d273b7fd7977047741aa03 Content-Type: text/plain; charset=ISO-8859-1 Use semicolons to separate statements: case 1000; when 100; "string1"; when 110; "string2"; else "Unknown"; end -Mario. -- I want to change the world but they won't give me the source code. On Sat, Oct 31, 2009 at 22:10, Braxton Beyer wrote: > 1000.case when 100 then "string1" when 110 then "string2" else "Unknown" > end > --0016e6d273b7fd7977047741aa03--