Beermann, Albert wrote: > > Hello Everbody ! > > With sql-studio i want to select some records from the columns table > (date or datetime fields with default definition) > > I can do: > > Select * from columns where datatype like 'DA%' > > I want to do: > > Select * from columns where datatype like 'DA%' and default > like '9999%' > > Error ! default no allowed > > use "DEFAULT" as default is a (reserved) keyword and interpreted different to your needs. "default" will not help as this is different to the columnname "DEFAULT" defined for DOMAIN.COLUMNS
Elke SAP Labs Berlin > > Any help welcomed. > > Best regards > > Albert > > ''''' > ''''''''' > (0 0) > +---------oOO-----------(_)------------------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> | > | Internet: http://www.piepenbrock.de <http://www.piepenbrock.de/> > | > +--------------------------------------oOO----------------+ > |__|__| > || || > ooO Ooo > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
