Subject Re: Query error From Mervyn Bick <invalid@invalid.invalid> Date Sat, 2 Sep 2023 13:29:06 +0200 Newsgroups dbase.getting-started On 2023/09/02 13:00, Tom wrote: > Revision: > > sql = "Select CAST(TestDate as Char(10)) cTestDate, d.TestDate, > d.Provider, d.Client, d.Category, d.Allergen, d.TestLevel, > d.StdTestRange, n.Demodata_Notes FROM DemoData d Left Join DemoNotes n > On n.Fk_DemoData = d.Pk_DemoData WHERE cTestDate LIKE :TestDate AND > LOWER(d.Category) LIKE :Category AND LOWER(d.Allergen) LIKE :Allergen > ORDER BY TestDate, Category, Allergen" > > gets me an 'Invalid Field Name' error message. :( Our messages have crossed.    CAST(d.TestDate as char(10)) cTestDate,..... The field in the CAST() function must be qualified as to whai tabe it comes from. Mervyn.