DECLARE @v1 sql_variant;
SET @v1 = '1';
declare @temp table (ID int )
select (case when SQL_VARIANT_PROPERTY(@v1, 'BaseType') in ('varchar','nvarchar','char') then 1 else 0 end)

Try this...

Dear Reader,

With the above code I a have tried to make a fairly minimalistic CSV generator. When run in SSMS you get a CSV tekst.

It is...

;
WITH
Digits0 AS (SELECT n FROM (VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'))x(n))
, Digits AS (SELECT CONVERT(VARCHAR(MAX),N) AS c, '%'+CONVERT(CHAR(1),N)+'%' s FROM digits0)
, F   AS (SELECT c AS...

It's becoming a contest between:

Brain (and calculating)
and
Brute Force.

Phil Parkin can you tel how you came to this anwser ?
Was is Brainpower or Brute...