CODEWITHSUNDEEP
sqlsql-servert-sql
madcolor
madcolor

Reputation: 8170

SQL IsNumeric(), shouldn't it return a bit?

I'm just curious to know why SQL IsNumeric() returns int instead of bit? Seems like it should return a bit.

Upvotes: 0

Views: 329

Answers (2)

Christian Hayter
Christian Hayter

Reputation: 31071

The bit data type was added comparatively recently in the evolution of Transact-SQL. You will find that a lot of system functions were at least designed, if not added, before bit was added. I have noticed that quite a few system procedures added since then do take bit parameters where appropriate.

Upvotes: 7

Maximilian Mayerl
Maximilian Mayerl

Reputation: 11359

Hm, yes, I agree with you, it would be more logical if it would return a bit. But in the end, it doesn't matter, does it?

Upvotes: 2

Related Questions