附上兩張圖片第一張圖片是問題第二張圖片是我嘗試過的代碼。我被附加 $ 困住了。我什至添加了我的代碼
T-sql：
CREATE TABLE Tab1 (
tname VARCHAR (50)
);
INSERT INTO Tab1(tname)
VALUES ('Ravi Ashwin'),
('Mahendra Singh Dhoni'),
('Shikhar Dhawan');
Select a tname, substring (tname, 1,6) AS First_Sic_character, LEN (tname) AS Character_count,
CASE WHEN LEN(tname) BETWEEN 0 AND 12 THEN 'SHORT & SWEET'
WHEN LEN(tname) BETWEEN 13 AND 15 THEN 'MEDIUM & PREMIUM'
WHEN LEN (tname) > 15 THEN ' LENGHTY$LOVELY'
END AS Category
From Tab1
uj5u.com熱心網友回復：
試試這個：
CREATE TABLE #Tab1 (
tname VARCHAR (50)
);
INSERT INTO #Tab1(tname)
VALUES ('Ravi Ashwin'),
('Mahendra Singh Dhoni'),
('Shikhar Dhawan');
Select tname,
LEFT(CONCAT(SUBSTRING(tname,0,CHARINDEX(' ',tname)),'$$$$$$'),6) AS First_Sic_character, LEN (tname) AS Character_count,
CASE WHEN LEN(tname) BETWEEN 0 AND 12 THEN 'SHORT & SWEET'
WHEN LEN(tname) BETWEEN 13 AND 15 THEN 'MEDIUM & PREMIUM'
WHEN LEN (tname) > 15 THEN ' LENGHTY$LOVELY'
END AS Category
From #Tab1
DROP TABLE #Tab1
uj5u.com熱心網友回復：
用這個
CONVERT(VARCHAR(6),tname SUBSTRING('$$$$$$',LEN(tname),6))
uj5u.com熱心網友回復：
with cte(name) as(VALUES ('Ravi Ashwin'),
('Mahendra Singh Dhoni'),
('Shikhar Dhawan'))
select name,substring(name,1,6)
,(case when length(substring(name,1,6))<=6 then concat(name,'$') end )::varchar
,(case when length(name) between 0 and 12 then 'SHORT & SWEET'
when length(name) between 13 and 15 then 'MEDIUM & PREMIUM'
when length(name)>15 then 'LENGHTY$LOVELY' end)Category
from cte
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/430064.html