--sql怎么取某个字符串最后一次出现的位置后面的字符串
declare @s varchar(max);
set @s = 'fj/2016815/2016081553677565.pdf';
select right(@s, charindex('.',reverse(@s))) AS 'aa'
返回结果如下图:
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUwAAABbCAYAAAAYyrzIAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAseSURBVHhe7Z1dj9PGGsf9nfaAln4XtKJ7lA9SqVLbw0VvipQbtBdHSBUth1Kp11xWkHZheRWIU+hS6OGdfWPJBs3x42TS6WQcj0M8nkx+lkbxTux5+fvZn/8zduzsxYsXyic9f/5c6fT69Wt1/vx5deXKVXXt2g31yy/XVK/3KwkNiAFiIOkYyF69eqUEgPLpm968eaM2NzfVhQsX1NmzZ0loQAwQA0sRA9mzZ88UCQ2IAWKAGKiOgWxjY0OR0IAYIAaIgeoYyGR4TUIDYoAYIAaqYwBgcsLghEkMEAOeMQAwPYXi7Ft99kUjNEo9BgAmwMRdEAPEgGcMZF+e/kaR/DRI/exJ/3CIxMD0GMgUi5cCclIhmAAKMbDcMQAwvXCpcOEfMRIBMssNmZSOP8CsAczBYKBI9TTAmQPLpIHZ6fbUtLTS6SlX8uTOwm4m//g7OzsT6fLly0rSpUuXJtLGxr+d+7jKSTFPTi4AE2AmD8ycmWqcuioH6PQkAE19KQNmV4RyLPIzs063CzCZ+2Xu2/MK9CKAdWJIXuYuy5xlkb+yHMB8+/atspMJTPmu90IV6dyVN6qTn2lc+yxL3tHREQ4zIVgsAtCabuMEMG3HdPXq1b/5Jxl+6uXw8FDJ9isrnakGM8syZaZ5u9Emy9ZtLRtaar3u3LmTP9aqp0QvgaXkCzCbPoAxlw8wGY7HHJ+ztK0SmCYgBR4yVyeLwFKckoDhxIkTlQwUqOnFXK/cscYGZeXOoz4BpjwGz07S/24OStFF1mXeUicBpmufZckDmABzFijFvM8EMOWfXdySOCV9QcP81GCQT9l2mYD58uVLZaeyOUxxmWO3mQNVoPrgwYOJ/V1lascs35nrrm1jzuv3+wzJGZInNcpyAtM0dbbDFEDoOTiZqxNo+jpM/c9vm0ZXvmsYb25Xtk9Z2bbLrDtNIA7T9WR60WN7e3v8TNGci8WQXJK56KkLgWbVE+5122Q7c71qv9i+B5g4zJjd4ixtqzUkl2G4OEvz4kYdYApAXOByDdV9htfTyjJh5Sqr7jBdgGm+pkOvCwgFghMuXMgpS36lXHU7hRMXxynzvbK9qyydpyEpf5vr0/aJ8TuACTBngVLM+0wA88yZM8XFCw0Ac35OD8fNubpuDgRfh1kGxrKLNlUu8mOAqeHtC04BpoDOTmVDctHNXGS/lU6nAKaGpqs8ydP9ttf19ub3dp79ne2kzTpd5Zh1lpXlKsNV1sHBAUNyhuRpD8kFmPZQUl/gEWcpjrK4dWY09JTtq66S287ShJQPsMq2/1hg1rkIJcC8f//+RNLA1K5b7r8UfcbAzN1lfrm8qKrTXRneVZD/7SpL50m/ZN3+NPOmrZtl6zLs+sz8ea3bdQBMHGbMbnGWtjkdpglMPQTXQCiAaczT+QDTdpC2c3Q5TNsZ2UNs+/tp27vcZNX29lyoAPPevXsTyQSmhmUBTOuGdtFPnJmAVE4wrrJ0nrRN1u1PnWe23SxH59tlV+Xresz6y/JcZZWVDzAB5ixQinkfJzD1T/2KW2ZGybxdRvIElDr5OMwadwdFuakA8+7duxNJg9GEpZxQxsAUd9lZKS4MFQ5zBExXWTpPACTr9qeZ57O/vY0uzy6nLN/c39ymrG57m/39fYbkDMnTH5LLnKRA0PVp5sm6TlFSbo6NEmDevn17Ik0AM4dlp7dSTF3oRWAqt2rJiUhfLXeVpfMEPLJuf5rfa1fnytP76TJMR2rWa7vsOttX1SvfA0wcZsxucZa28bQiT6gKMG/evDmR9NVvfQO7OEhJY2Dm7lIcZnGFPP/UwHSVFUOeQNRsh/13nTbu7e3hMHGYaTtMT34s3WYCzK2trYmkL+Ksra0Nr4KPkgZm8TNJgagxtSHu3VVWLHmm8/yYNgFMHOYsLi7mfXCYnugXYF6/ft07CTD1LUSuzzplLeq2u7u7OEwcJg7TkzFJbSbA3NzcJNXQAGDiMGN2i7O0DYfpiXVeFOf3ojh0QqeUYwBgegKTzVAABVAgO//9j4qEBsQAMUAMVMdAqw5T3mMT0xJbe2LShragAArkDw9qU4TYABVbe9o8NtSNAigwqUCrwJTfV8e0xNaemLShLSiAAi07zNgAFVt7CFAUQIG4FMBhGscDYMYVnLQGBWJToFVgyo2jMS2xtScmbWgLCqBAy0NyeXtiTEts7YlJG9qCAiiQA/PoaKDeHfaDp8Hgg3r65/+Uq/6L639/j/n6D8P2leXPo/26PQQFCqAACpQpkPVzYB68ex88CaD+ePJUVdZ/87RaXT2tbthtLMufsS+6PYQKCqAACkQHzA8fPqjHfzxxA1NgmD+XcfyYMQ3MsvwZIWmeKHR7CBUUQAEUKAdm/0jtHxwGT4McmNuPc2BO1P+D+jRbVV/dGLXpxtBhbh2U5c+n7bo9hAoKoAAKLBgw19V/NMQvrqtsDExXPsAkvFEABcIokL3PHd7e/rvgSeYMH/3+WLnq3/pq9a/huAzNV/+ltvI2luXPo/26PWFkpxYUQIFFVCA7fN9Xu3sHwZMA6uGjbdVW/XafdXsW8SDSZhRAgTAKZIf57To7u/vB02AwUL89/F21Vb/dZ92eMLJTCwqgwCIqkL07fK/e7uwFT0c5MP/726P8/sp26rf7rNuziAeRNqMACoRRILt165Yi/aVBGNmpBQVQYBEVyH/pc5T/2qad1O/3W6vb1WdpDwsKoAAKlCmQzfLmtHnuIzenS3kxfBImKIACKDBNgQKYbS1S958vd6JIberQlv7UiwIoUE+B1oEpzjIGaEo7WFAABVAAh+nhYnGY/KOgAApUKYDDHMEUh1kVKnyPAijgAcyfVCfrqJ8a0Gruc5i9L9Q/jn2hfs4heG5t+LSjk9/6zZHiMBs4wBSJAokpMAWY99XXn+hHrDUHzLnOYY6B+Z06mZ1S5zyG4nr+FIeZWGTTHRRoQIE0HabhNH0vKOEwG4guikSBxBQogDn9NRWX1Hr2T3WxgddY6PsvK6FWAPCUOnlMO17DPcp35sOGjx03/vZ3mTjMxCKb7qBAAwoUwJz+mgh5cG8OzDk81dx+FYb3HGYBxePqs95wPvLnz4+rbO27fH1TfZZDdDxP+e0plckcJg6zgVChSBRAgdaB6TWHaQOwAGjuHl35MwITh8k/AwqgQJUCQ2BOfU2FOEzjSedzfJ1FLYc5uvpdDN81KOcITOYwq0KF71EABVoHprfDNK56lw3Ji3wcJlGNAijQkAIFMKe/puJi4TAvNPAai2qHObo9qHCSxsUc223qiz6yzYzAxGE2FGEUiwIJKVAAs63XRNS7Sj68Ib3yivqM2zCHmVBU0xUUaEiBITBbek1FtcMcAXKGq951wYrDbCjCKBYFElKgAGZbr4nwdpgzusY60MRhJhTVdAUFGlKgAGZbr6jwdpgBgInDbCjCKBYFElJg9Eufdl5RgcNMKJLoCgosgQIFMNtOvJ5iCSKNLqJAAgrwmPEEDiJdQAEUCKMAwAyjM7WgAAokoADATOAg0gUUQIEwCgDMMDpTCwqgQAIKAMwEDiJdQAEUCKMAwAyjM7WgAAokoADATOAg0gUUQIEwCgDMMDpTCwqgQAIKAMwEDiJdQAEUCKMAwAyjM7WgAAokoADATOAg0gUUQIEwCgDMMDpTCwqgQAIKAMwEDiJdQAEUCKMAwAyjM7WgAAokoADATOAg0gUUQIEwCgDMMDpTCwqgQAIKAMwEDiJdQAEUCKMAwAyjM7WgAAokoADATOAg0gUUQIEwCgDMMDpTCwqgQAIKAMwEDiJdQAEUCKPA/wH4yV+liQB5TQAAAABJRU5ErkJggg==" alt="" />