ACCESS数据库：

select id,foldername,mid(classbasicinfo,1,instr(classbasicinfo,"||||")-1) as 栏目图片 from ks_class where tj=1 order by folderorder

SQL数据库：

select  id,foldername,substring(classbasicinfo,1,charindex('||||',classbasicinfo)-1) as 栏目图片 from ks_class where tj=1 order by folderorder