WOW! Never knew it!

look like, We can use any currency symbol, sql server supports.

select £ --- Also returns "0"

My guess is, when it sees any value/expression it tries to identify the datatype. Probably based on currency sumbol, it might identified it as "Money" datatype and showed default value for that...

Ramireddy you guess is right

we can check by following sql

SELECT cast(sqlvariantproperty($,'BaseType') as varchar(20))

Yes....I saw this some time back some one using this..

But i forgot it.....

Waiting for the Rupee symbol to get there :-)

Ramireddy, you can use any currency symbol in place of dollor Jacob, we may get Rupee symbol soon

I have added some other methods in the code. You all may need to relook it.

I think expression $ is always considered as Money Datatype...we can check this also.. select len($)

Huh??!!! I guess SQL Server is more of a magic Pandoras box :) Superb! Thank-you for sharing!

Cool..never knew about this!

Could someone give a real-world scenario when/where this could be applied and why?

TIA

Excellent trick...!!

Thanks for sharing..

Hi Sir I have learn many new thing from this and Pinal Dave's blog. I read here many interesting, I have create and Quiz based on Count (*) and select $ http://current-affairs-quiz-questionsanswers.blogspot.com/2011/06/sql-puzzle-based-on-select-count-t-sql.html

Once go through it.

Really great !!! Never knew it. Thanks for sharing.

Hi Madhi, here is my try...

SELECT (ASCII('A')-ASCII('A'))+$

select convert(int,'') will produce zero but '' as is (not converted char) is not numeric - and its logic ;)

Yet another way . . .

declare @zero bit; set @zero = 'false';

select convert(int, @zero) as zero;

Still don't know why I'd ever need to do this.

Select cast('' as int) Select floor(rand()) Select datediff(mi,'','') Select min(number) from master.dbo.spt_values where type='P' Select count() From sys.databases Where 'A'='B' Select count()-count(*) From sys.databases -- could be any table Select min(status) from sys.systypes

Easy to find a lot of other ways... ;) those are just the first that crossed my mind

cool, I guess now we can use currency symbols too

Is this useful???

csanabria, it is useful it you want to ask a tricky interview question