> You can use a LIKE filter on the e-mail address field in your view
> definition, so there's no NOT NULL column that is not populated.
Viz.:
CREATE VIEW mail_example_com AS SELECT * FROM imail_master_users
WHERE mailaddr LIKE '[EMAIL PROTECTED]'
Or you could use the mail topdir:
CREATE VIEW mail_example_com AS SELECT * FROM imail_master_users
WHERE userdir LIKE 'E:\IMail\mail_example_com\%'
--Sandy
------------------------------------
Sanford Whiteman, Chief Technologist
Broadleaf Systems, a division of
Cypress Integrated Systems, Inc.
e-mail: [EMAIL PROTECTED]
SpamAssassin plugs into Declude!
http://www.mailmage.com/products/software/freeutils/SPAMC32/download/release/
Defuse Dictionary Attacks: Turn Exchange Addresses into IMail Aliases!
http://www.mailmage.com/products/software/freeutils/exchange2aliases/download/release/
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html
List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
