Loading

how to display boolean value as another string

Raghvendr Singh

14y1.7k

Hi friends!
Is this possible to display boolean value(true/false) as another string format(valid/Invalid) by select statement?If possible,please help me to do this.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
I assume you mean the BIT type as SQL Server has no BOOLEAN type as such.

Assuming the BIT value will be either 0 or 1 and not NULL, I'd try:

SELECT CAST(CASE @value WHEN 1 THEN 'Valid' ELSE 'Invalid' END AS varchar)