IF value = 'x' then substring

lstz6jyr 于 2023-02-28 发布在其他

关注(0)|答案(1)|浏览(105)

I am looking to output the substring where country = 'us' only and leave the substring blank for all other countries. I have tried the below commented-out part but I am not sure my structure/logic is correct. Any help would be great

SELECT DISTINCT country,   ID, Name --, IF(country ='US', "SUBSTRING(ID, 3, 5)", " " ) AS substring
FROM TestTable

sql-server

来源：https://stackoverflow.com/questions/75544470/if-value-x-then-substring

1条答案

按热度按时间

2fjabf4q1#

As @Squirrel mentioned in the comments you can use CASE to fix your issue, the code then would look like this:

SELECT DISTINCT
    country,
    ID,
    Name,
    CASE
        WHEN country = 'US' THEN SUBSTRING(ID, 3, 5)
        ELSE ''
    END AS substring
FROM TestTable

赞(0）回复(0）举报 2023-02-28

我来回答

IF value = 'x' then substring

1条答案

相关问题

热门标签

最新问答