Rick Ratchford wrote: > So what I need to do then is to make the return of strftime of type INT. > > Can CAST(strftime('%d', Date), INTEGER) be used in this context, or is there > another way? > > Rick,
You could use a cast (with correct syntax) as you have suggested CAST(strftime('%d', Date) AS INTEGER) Or you could simply provide the day you are checking for as a string. To do this, surround the number with single quotes to turn it into a string literal. SQLString = "SELECT strftime('%d', Date) as Day, IsSwingTop1 as Tops, IsSwingBtm1 as Btms " & _ "FROM TmpTable WHERE Day = '11'" HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users