SQL表中某字段数据的读取

select fileName from FileInfo where fileId = 4 --查询出来的结果是'我的文档' -现在我要取‘我’ select substring(fileName,1,1) from dbo.FileInfo where fileId = 4 -取'的' select substring(fileName,2,1) from dbo.FileInfo where fileId = 4 -取'文'