Re: Is systables.tabname case sensitive?

Posted in 1999

a_blonde@mindless.com — Wed, 27 Oct 1999 05:53:34 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > Greeting... > > Is systables.tabname column case-sensitive? Yes it is Dude, and all table names are stored in lower case. > What is the different between these two sql statement: > A) select 1 from systables where tabname="LPAtable" ==> no row found > B) select 1 from systables where tabname="lpatable" ==> one row > returned Dude, I think you knew the answer to that when you posted. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com