SET CENTURY ON

>I have shortdatetime fields stored on SQL Server. I pull that into a Cursor, and the cursor sees the 2 digit year instead of 4. How can I change that?
>
>Here is the relevant code:
>

>lnConnHandle=Sqlstringconnect("driver={SQL Server};server=SQLSRVB;uid=name;pwd=pass;database=db")
>lcSQLConn = SQLEXEC(lnConnHandle, "SELECT * FROM members WHERE (active = 1 AND last_update > '1/1/1900')",'MEMBERS')
>IF lcSQLConn = -1
>	MESSAGEBOX("[ERR]Failure to connect to SQL Server MEMBERS")
>	lcError = .T.
>ENDIF
>= SqlDisconnect(lnConnHandle)
>

>
>TIA,
>MAC