开发者

Extract initial character from field in MS Access

I have a table with this record

Title             Name
Rumah Sakit       Puri Medika

I want to extract initial character from each field so it will dis开发者_JS百科play "RSPM"

Thanks


SELECT Left([Title], 1) & 
Mid([Title], InStr([Title]," ") + 1, 1) & 
Left([Name], 1) & 
Mid([Name], InStr([Name]," ") +1, 1)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜