ALTER TABLE table ADD COLUMN Start_Date TEXT(6)
ALTER TABLE table ADD COLUMN End_Date TEXT(6)
update table
set Start_Date = Left(column,6),
End_Date = Right(column,6)
DavidN
- 591
- 4
- 9