There are a number of ways depending on how the value is stored.
I suspect that they have been stored as strings in which case you can use
left_string, right_string and middle_string to separate the 1 from the rest
of the date. Note that the names, left_string etc., are fake and you
should chec
Are you inserting them as strings or as dates?
At 02:50 PM 3/29/2001 -0600, gary sanders wrote:
> We have an older system that we have to put up with for another
> year, their "fix" for y2k was, like several others, to place a number one
> before the date "ex 1000329 or 1010329 which is
