 | | | How to select records from columns with where default = | How to select records from columns with where default = 2007-01-08 - By Beermann, Albert
Back
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:a.beermann@(protected)
<mailto:a.beermann@(protected)> |
| Internet: http://www.piepenbrock.de <http://www.piepenbrock.de/>
|
+-- ---- ---- ---- ---- ---- ---- -----oOO-- ---- ---- ---+
|__|__|
|| ||
ooO Ooo
|
|
|