>
> In SQL it would be:
>
> SELECT
> ID,
> CASE
> WHEN ImageURL6 IS NOT NULL
> THEN numPhotos = 6
> WHEN ImageURL5 IS NOT NULL
> THEN numPhotos = 5
> WHEN ImageURL4 IS NOT NULL
> THEN numPhotos = 4
> WHEN ImageURL3 IS NOT NULL
> THEN numPhotos = 3
> WHEN ImageURL2 IS NOT NULL
> THEN numPhotos = 2
> WHEN ImageURL1 IS NOT NULL
> THEN numPhotos = 1
> ELSE
> THEN numPhotos = 0
This last one should be without the THEN.
Jochem
> END AS numPhotos
> FROM
> cdmdatafeed
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
