Ryan, try (OptionValue != 'Total')
--- In [email protected], "rgwilson26" <[EMAIL PROTECTED]> wrote: > > I am wondering is anyone can help me on the sytna for a not equal to > value using a cfc? I wrote this query in sql server and it works fine, > but my cfc doesnt like the '<>' for not equal to. Does anyone know the > correct way to write this? > > Thanks, > > *******my query******** > > SELECT OptionValue > FROM dbo.OptionLOV > WHERE (OptionType = 'CostCat') AND (OptionValue <> 'Total') > -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
