Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading to match what the question is really about instead of deliberately trying to mislead ?
a litle modification in the question and a missing reference .. and it would go for the header 😀
DECLARE @vchrIsNumeric CHAR(2)
SET @vchrIsNumeric='3 NAME'
SELECT 'Is Numeric'
SELECT 'Is not Numeric'
output would be the same ..(might put a dot for a second :-P)
and here is the missing reference on IS_Numeric :
This question is about the default length used for the VARCHAR data type. I am expecting a variation on this question to pop up soon where the answer is VARCHAR (30).
yes.. It might :hehe:
as mentioned in msdn :
When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified when using the CAST and CONVERT functions, the default length is 30.
Wondering what I would do next , when I am done with this one :ermm: