>could you explain a little more about the 102 thing, I can understand the other stuff. the other thing is that this convert the date to string stuff, how do i convert it to date stuff?
Selim,
The 102 means an ANSI compliant date (yy.mm.dd). 101 is a US date (mm/dd/yy). There's a complete chart in the SQL Server Books Online (BOL). If you don't have access to that, you can probably find the same information on the MSDN web site by doing a search on CONVERT.
As I said in my post, SQL Server doesn't support a date datatype. It supports a smalldatetime (4 bytes) and a datetime (8 bytes).
I'm assuming that you're wanting to use this in filtering a SELECT statement. For reasons of pure speed, you wouldn't want to have the overhead of the conversion function calls in it, you'd be better off using the same data type as in the table. You might, therefore, want to look at the DATEADD() function instead.
George
Ubi caritas et amor, deus ibi est