ok i lucked out.
got every thing to work, but still am not sure why.
why : can you use <> in your select statment & not NEQ
and why: can you only use NEQ & not <> in your CFIF statment for an Output?
Thank you
-paul
SELECT PracticeGroup
FROM tbl_Practice
WHERE PracticeGroupID = #set_PracticeGroupID#
And PracticeGroupID <> 18
<cfif set_PracticeGroupID NEQ 18>
<cfif set_PracticeGroupID IS NOT "">
Practice Group: #Trim(Practice_Type.PracticeGroup)#
</cfif></cfif>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
