Good guess, but the quotes "UPPER" were added automatically by VS not me. When I enter UPPER normally it always saves it quoted.
I'm not sure if this parsing is done by VS itself of by the FBData factory. Do you know? Rick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Friday, January 19, 2007 5:01 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] use UPPER function in select Rick Roen wrote: > Select <field list> from CONTACTS where ("UPPER"(NAME) like @Name) Just shooting, I have here no VS, but shouldn't be there Select <field list> from CONTACTS where (UPPER(NAME) like @Name) UPPER without quotes? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
