根据数据库值的前3个字母进行查询

I can get sum value of my "ctr" from my database with below query. But my ctr is longer than 5 letter. I must check the first 3 letter and get sum value acording to this 3 letter I can get sum value of my "ctr" from my databas