I don't think you can do equality (inequality) comparisons on a text field in TSQL or ANSI SQL. You can do LIKE comparisons.
> I found what was causing the problem and maybe someone can explain why - > -the field was originally set as a text field... I changed it to nvarchar > and the error went away using: > > where members.speakers <> '' > > the error appeared using the above code until I made that field data type > change > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
