How to select records from columns with where default =

[Beermann, Albert]

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