>
> select *
> from table
> where #groupID# = groupID or #groupID# IN (sharedGroupIDs)
If I understand what you want to do...
','+cast(sharedGroupIDs as varchar(4096))+',' like <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="%,#GroupID#,%">
What this will do is put a comma at either end, then compare your value
with a comma at either end - if you just look for the number, then "1"
will return anything that contains a "1"
Oh, and CFQUERYPARAM!!!!!!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
