clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36253 in the last week).

CREATE TABLE Rates (QuestionDetailValue NVARCHAR(255)); INSERT INTO Rates VALUES ('10'), ('👍👍👍👍👍👍');
2 rows affected
 hidden batch(es)


WITH tt1 AS( SELECT CASE WHEN try_cast(QuestionDetailValue as int) IS NULL THEN N'Bad' ELSE N'Ok' END AS TryCast FROM Rates) SELECT TryCast FROM tt1 WHERE TryCast = N'Bad'
TryCast
Bad
 hidden batch(es)