thanks! i have seen the sqlite quirks page before but just added this to my queries thanks to you