There is nothing wrong with the logic of using TEXT instead of varchar (or nvarchar), except in the situation in which logging is required using TRIGGERS. In this case you...
Roger Layton (roger@rl.co.za
)
Managing Director, Roger Layton Associates (Pty) Ltd (www.rl.co.za)
TEL: +27-11-880-9153
FAX: +27-11-447-5799
MOBILE: +27-82-881-0380