Peter, Unless you have a field with a Database Name of "C1" that would not work. (You likely mean $Request ID$ or $Entry-Id$, or some such field name like that.)
-- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Nov 15, 2007 10:02 AM, Joran, Peter P, CTR, OSD-CIO <[EMAIL PROTECTED]> wrote: <snip> > This does not work > > SELECT C536870937, > CASE > WHEN C536870937 = '1' THEN 'January' > WHEN C536870937 = '2' THEN 'February' > WHEN C536870937 = '3' THEN 'March' > ELSE 'Unknown' > END > Month2 > FROM T689 > WHERE C1 = $C1$ > > Pete _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
