LIKE 1

[chrisppppp]

Crystal Server Management Studio 2005

Hi, i have a query with this line in it:

MAX(CASE tblTrans.PremiumID WHEN 'PI' THEN tblTrans.Premium ELSE 0 END) AS PINetPremium

i would like it now to say when it starts with PI, i know how to use the like and %, but am just not sure how to do it, any chance someone can give me some help?

Cheers

 

[bborissov]

MAX(CASE WHEN tblTrans.PremiumID LIKE 'PI%'
              THEN tblTrans.Premium 
         ELSE 0 END) AS PINetPremium

--- or

MAX(CASE WHEN LEFT(tblTrans.PremiumID,2) = 'PI'
              THEN tblTrans.Premium 
         ELSE 0 END) AS PINetPremium

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[chrisppppp]

Thats perfect, thanks a lot for your help.