help with sql statement

[muffntuf]

Does anyone know of a better way to write this sql statement? It seems that I need to exclude the and not like portion, but I don't think this is getting excluded from results.

'OTHERCONDIS' = CASE WHEN GLT_Dist.Acct_Nbr LIKE '01-4%' OR GLT_Dist.Acct_Nbr LIKE '02-4%'
OR GLT_Dist.Acct_Nbr NOT LIKE '01-4___-13-00-%' OR GLT_Dist.Acct_Nbr LIKE '02-4___-13-00-%'
OR GLT_Dist.Acct_Nbr LIKE '01-4___-17-00-%' OR GLT_Dist.Acct_Nbr LIKE '02-4___-17-00-%' THEN (isnull((Cr_Amt),0)- isnull((Db_Amt),0))END

Thanks,
muffntuf

 

[Madawc]

I'd do it as several Crystal formulas, things like

GLT_Dist.Acct_Nbr LIKE '01-4%'

This would come out as a boolian, true or false and you could display it to check it was coming out OK. You could then combine it with the other tests in another formula field. If the boolian were @Acc_1_4 then you could just say @Acc_1_4 or not @Acc_1_4

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10