On 12/22/2010 7:25 PM, CDN Mark wrote: > Hi Igor, > > not checking for, want to fill in/replace blank or null fields with at least > one character
So, does the statement I've shown not do this? Here it is again: UPDATE Aircraft SET CN = '*' where CN = '' or CN is null; In what way does it fail to meet your expectations? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users