SQL Server reference on MSDN shows "SUBSTRING ( expression , start , length )" syntax: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ setu-sus_6btz.asp
I can verify this if it would help. -----Original Message----- From: [EMAIL PROTECTED] [mailto:jboss-development-admin@;lists.sourceforge.net]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11:03 PM To: [EMAIL PROTECTED] Subject: [JBoss-dev] [ jboss-Bugs-619969 ] SQL Server substring syntax is wrong Bugs item #619969, was opened at 2002-10-08 08:15 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=619969&group_id =22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Vinh Nguyen (softwaremasters) Assigned to: Nobody/Anonymous (nobody) Summary: SQL Server substring syntax is wrong Initial Comment: The function mapping for substring for SQL Server (both 7 and 2K) in standardjbosscmp-jdbc.xml is currently: substring(?1 FROM ?2 FOR ?3) This is incorrect. The correct syntax for the substring function is: substring(?1, ?2, ?3) ---------------------------------------------------------------------- Comment By: Stephen Coy (scoy) Date: 2002-10-31 18:02 Message: Logged In: YES user_id=463096 My reference "SQL in a Nutshell" (O'Reilly) says otherwise. Can you provide some other documentary evidence of this? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=619969&group_id =22866 ------------------------------------------------------- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development ------------------------------------------------------- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
