This will work:-
insert into t_au select ZEROIFNULL(MAX(tid))+ 1, 'WWW' from t_au;
Pulak
Attachments
Library
Quick Reference
Archives
Sample Index
2005 Indexes