Yes, that helps. Thanks Razzak.
I was hoping to update several hundred rows with one update command.
But I can cursor through them and do the variable thing - there aren't
that many rows and it only needs to be done on occasion.
Have a good weekend Razzak.
Thanks again
Doug
A. Razzak Memon wrote:
At 08:59 PM 12/19/2008, Doug Hamilton wrote:
So, how do I convert a date-looking text into a valid date?
Doug,
A quick test at the R> prompt reveals the following results:
SET VAR v1 TEXT = NULL
SET VAR v2 DATE = NULL
SET VAR v1 TEXT = '4/9/2008'
SET VAR v2 = .v1
SHOW VARIABLES
V1 = 4/9/2008 TEXT
V2 = 04/09/2008 DATE
Hope that helps!
Very Best R:egards,
Razzak.
