Eugene,

i tried this it select $ returns 0.00

while when i tried with other sumbols (!@#$%^&*_+) all returns an error..

when you run query for:

select convert(float,'-0')

it runs successfully

while if we put any other sign in SELECT CONVERT(INT,'.') other than '+/-' it will gives the same error as float will...

yes,

SELECT CAST('1D2' AS FLOAT);

when I ran this query it ran successfully and gives 100 in output.. I dont know how it cast it to 100 :w00t:

While when I ran...

i was just playing with CONVERT and faced this issue so just want to know about this weird behavior of float and INT in convert...

tricky question

good points ny cliff and Bob...

can anyone give the answer of Loner..

I am also confused on this now.. wch one is correct

whts this.. :w00t:

good one Adam 😛

Good question

David,

select ISNUMERIC(@value1+'.')

it also gives error:

Error converting data type varchar to float.

very easy one...:-):-P

multiple getdate statement just to make question tricky

good one Carlo

whats question is this... 😎

good point Adams it should mentioned clearly in question but as in second data is was mentioned 1/31/2005 so it makes clear that format is mm/dd/yyyy 🙂