Determining, then changing, a column's data type

[Moe1950]

Isn't the WHERE handled by the CASE statement?

If not, then the WHERE is the CASE statement and it would seem to be a bit redundant to add a WHERE that said the same thing.

SELECT
clmns.name AS [Name],
usrt.name AS [DataType],
ISNULL(baset.name, N'') AS [SystemType]
FROM <name of my table>
WHERE baset.precision = 'float'
CAST(
   CASE 
       WHEN baset.precision = 'float') THEN
'Yes' ELSE 'No'
END

That doesn't make sense to me.

Or, are you saying I don't need the CASE statement at all and I just need a WHERE clause?