SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with cte1 as
(
select 1 as Appid, 'A' as value1, 'B' as value2
union all 
select 2,'C','D'
),
cte2 as
(
select 1 as Appid, 'A' as value1, 'B' as value2
union all 
select 2,'X','D'
)
, cte3 as (
select cte1.*,cte2.* from cte1  join cte2 on cte1.Appid!=cte2.Appid
) select 
Msg 102 Level 15 State 1 Line 15
Incorrect syntax near 'select'.

Declare @str Nvarchar(MAX) ='Minneapolis c0 02/14/18'
SELECT left(@str,len(@str)-11)


(No column name)


Minneapolis


Declare @str Nvarchar(MAX) ='Minneapolis c0 02/14/18'
select substring(@str,1,11)


(No column name)


Minneapolis


Declare @str Nvarchar(MAX) ='Minneapolis c0 02/14/18'
SELECT REPLACE(@str, 'c0 02/14/18', '');


(No column name)


Minneapolis