and 03 indicate the media type and the number before the dash will match,
couldn't you do something like this pseudocode:
select left(id, 4) AS primaryID, right(id, 2) AS mediatype,
othercolumnshere
from yourtable
<cfoutput query="yourquery" group="primaryid">
#name# <cfoutput><cfif mediattype is 1>DVD<cfelseif mediattype is
3>VHS</cfif></cfoutput>
----- Original Message -----
From: "B G" <
> That may be possible. Though it's not always up to me to get the
marketing
> dept and the DB people to do work so my life is easier.
>
> Nonetheless...The basic nature of this kind of compare is eluding me.
Even
> if I had two records, one with DVD and one with VHS in the MEDIA_TYPE
field,
> I'd still need to have some way to identify that while displaying the
> records.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]