如:字段sdate(20021009),现在我只要取出200210就行了,在SQL语句中怎么写,用DELPHI开发的
---------------------------------------------------------------
left(sdate,6)
---------------------------------------------------------------
mid(sdate，1，6)
---------------------------------------------------------------
Agree with upstairs
in Access, if sdate is text type,u can use it as so
but if sdate is datetime type, u can use as:
format('yyyymm',sdate)