开发者

Extract initial character from field in MS Access

开发者 https://www.devze.com 2023-03-03 13:57 出处:网络
I have a table with this record TitleName Rumah SakitPuri Medika I want to extract initial character from each field so it will dis开发者_JS百科play \"RSPM\"

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

精彩评论

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

关注公众号