T.hank you kindly for your response, Yes, the "ID" field is numeric. I will read up on SQL Injection.

Jeff,

After a little trouble I have got it working. When I attempted to use it as a SqlCe CommandText string surrounded by inverted commas, I was always getting...

Jeff,

Just entering SELECT YEAR(GETDATE()) give the error Function is not recognized by SQL Server Compact Edition of Function [Year]

Running DATEPART returned 2010

Jeff,

Year = A similiar error, Error Parsing Line 1 at 29 error = (

DatePart = error Parsing line 1 at 33

I am using Northwind.sdf Employees table which has a...

Jeff Hi,

No matter what I try, I cannot get your code snippet to work, is there any possibilty you could expand it to show its used with code and using...

Jeff Hi,

No matter what I try, I cannot get your code snippet to work, is there any possibilty you could expand it to show its used with code and using...

Jeff,

Thank you for your response, I was not offended by your comments, maybe I expressed my response badly. Thank you for the code sample.

My code was attempting to calculate...

The following corrected code is used just to calculate the days to the next birthday only from dates within a SqlCe database, it is not being used to calculate the...

Found error.

Jeff Hi,

Thanks for your response. Some of the information was useful, but I have now reached the conclusion that as I have managed without SSMSE SP2 for over a...

Thanks for your response. Unfortunately this did not work. The only SQL Server I have on my machine is SQLServerCe 3.5. I have tried every combination without...

Thank you for your response. I will remove the default GetDate() and see what happens.

Have removed GetDate() and updated dataset etc. No change. Currently I have six...