Kris, Inequality <> works just fine for MS SQL Server TSQL for versions 2000 and 2005.
Teddy On 10/5/06, Kris Jones <[EMAIL PROTECTED]> wrote: > > 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:255685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
