在SQL Server中选择字符后面的所有内容

DECLARE @inputString NVARCHAR(100) = 'example:text';
DECLARE @delimiter CHAR(1) = ':';

SELECT 
    SUBSTRING(
        @inputString, 
        CHARINDEX(@delimiter, @inputString) + 1, 
        LEN(@inputString)
    ) AS Result;

DECLARE @inputString NVARCHAR(100) = 'exampletext'; -- 没有分隔符的情况
DECLARE @delimiter CHAR(1) = ':';

IF CHARINDEX(@delimiter, @inputString) > 0
BEGIN
    SELECT 
        SUBSTRING(
            @inputString, 
            CHARINDEX(@delimiter, @inputString) + 1, 
            LEN(@inputString)
        ) AS Result;
END
ELSE
BEGIN
    SELECT NULL AS Result; -- 或者你可以选择其他默认值
END