Hi, Try this Where OptionValue <>'Total' insted of OptionValue <> 'Total'
--- In [email protected], "Doug Lowder" <[EMAIL PROTECTED]> wrote: > > Ryan, try > > (OptionValue != 'Total') > > > --- In [email protected], "rgwilson26" <ryan.wilson@> > 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/
