Hi,
select * from sys.all_tab_columns where DATA_TYPE like 'DA%' and data_default
like '9999%'
works perfectly here ...
Flo
Beermann, Albert schrieb:
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
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]
