WHEN sa.PhoneHome =''
WHEN sa.PhoneHome !='' and sa.PhoneWork !=''
THEN convert(varchar(35), sa.PhoneHome+' / '+sa.PhoneWork)
ExpireDate=convert(varchar(10), ma.maExpireDate, 101)
FROM Subaccounts sa, MasterAccounts ma
WHERE sa.CustomerID = ma.CustomerID
/* remove the last line if you don't want it to be specific to that account
> And would anyone have this in a Crystal Report at all :-) or the
> for Crystal Report but instead of using accounttype= what it does can it
> changed to accounttype=*
> select Login, FirstName, LastName, PhoneHome, PhoneWork, AccountType,
> LastModifyDate, TimeLeft from SubAccounts where AccountType='casual 100'
Just replace the 'Unlimited' with 'casual 100' and add
AND sa.TimeLeft < 120
For more information about this list (including removal) go to: