Hi Bill,

Further playing around and the SUBSTR() function seems to work for me. Now just to deal with "?" in null date fields. Which eejit decided that nulls should be question marks. SQL just coughs up furballs all over the place, numerics, booleans, dates - grrrr