Joined: 14 Jan 2013
Online Status: Offline
Posts: 3
Topic: Case statement Posted: 15 Jul 2013 at 10:13am
Is it possible to use multiple fields in a case statement
like:
case field 1, field2
WHEN '001':'lb' THEN @LB_WEIGHT
WHEN '001': 'KG' THEN @LG_WEIGHT
WHEN '002': '' THEN @KG_WEIGHT
;
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum