I had used IsNumeric functions of MSSQL in my stored proc. I was supposed to do some other actions based on the results of IsNumeric function.
If IsNumeric(@var)=1
Select ‘True’
Else
Select ‘False’
Surprising and shockingly I found strange results. Here’s the sample. Note down your answers before you check the output of the below 3 statements.
Select IsNumeric(‘1D’)
Select IsNumeric(‘D1’)
Select IsNumeric(‘1D1’)
Yes, the SQL treats ‘1D1’ as numeric.
This happens with only 2 letters ‘D’ and ‘E’.
If the entire string which is used for check has only one character and that one character is either ‘D’ or ‘E’ then the string is considered as numeric.
I am not very sure about the reason behind this behavior of SQL.
If anyone has answer for this please comment it to my post.
Every December I see people wishing for a good start of the year. They plan well and execute it so that year does not start with some disaster (exaggerated). And I used to watch these guys and smile ironically.
But this time I was desperate to wish. Almost half a year I waited for 2008 to end. My life was no special to world. The world economy fell, recession, cost cutting, job cuts, hike in prices of everything etc. Same with me personal life, investments, profession, no hike n bonus almost everything got hit. Luckily my job was safe. J
Surprisingly when December came I just left the wish aside. I thought let it happen however it has to. Last week of December came and as it all was about to happen as it used to have for previous several years, planned to have a get-together with friends. If it misses then with family, no third option.
Surprisingly third option bubbled up from no where at the last 2 hr of 2008. J
Unfortunately or may be fortunately friends dint turn up. We roommates (me, nagi and pummy) were standing outside our house planning to leave to home (in tumkur) to join our family. Pummy cracked a joke in between saying “baro kodchadri ge hogbidona”(come lets go to kodachadri). I joined my words with him “nadi maga” (lets go buddy). We 2 were sure that nagi would get surprised. As expected he was shocked to hear us saying that, n for all 3 of us surprise we had got out bag ready n went for trip as just spoke for fun in just 10 min.
4 of us me, nagi, pummy and pummy’s new swift car, started our journey at 10 P.M. J
Again change in the plan on our way. J We decided to halt at home in tumkur take blessings from our parents for new year and start again at 5 A.M. Frankly speaking I wasn’t sure that we will go to trip till we started again at 6 A.M.
We absolutely had no idea where we are going and how many days we are going. On the way we decided to go to kodachadri as we planned. On the way we saw few places and we landed at the base of kodachadri. Only 4 wheel drive vehicles can climb up. Only other option was trek.
I force the other 2 to trek. We parked car, had some food n snacks and started trek. The path was either dust or small rocks nothing else. Then we realized y only 4 wheel drive vehicles. The jeeps were actually climbing the rocks. We started taking short cuts for trek. The entire trek to hill top temple will not be said here, will be kept secret. J
Once we reached top, we went to temple, again climbed top to see other places. Sat there and started thinking WHAT NEXT??? J
“Hosa varshakke, devra aashivada”, lets got to Kollur. Once we reached kollur, we took the first building we saw in our way and rented a room there. Got up in the morning, went to temple, finished our pooja and came back to room. Again the same question, WHAT NEXT??? J
We came up with lot of places, finally decided to go some place which we have not been. Finalized on “MUTTODI Forest”. We called up one of our friend who is ranger. Within 15 min our accommodation was arranged. Thanks to Rakesh. We were supposed to reach there by evening 7.
On our way we visited Aagumbe (the highest rainfall region of Karnataka). One thing which waters my mouth is the sambar I had in aagumbe hotel. Took snaps from the view point and continued our journey to muttodi. On the way we might have asked around 50 people the route to muttodi. None of us knew where we were. We were surprised to see a coffee day on the way to forest, a very nice location with cool ambiance. The journey over the coffee estates and forest was awesome, no words to express it. It was night 7:30 by the time we reached muttodi forest. We had to wait for Muttodi forest ranger for some time. We came to know there was no cottages available. Oops. But nothing to worry, the ranger took us to his house and we started talking. We discovered that he is my dad’s friend. Cool. The cottage was somehow arranged for us. It was dam cold and dark there. Lights will go off at 10:30. We had dinner by that time and slept.
Woke up in the morning to see the beauty of nature. Wow we actually had the best cottage. It was the last one inside the jungle, river flowing in front of our cottage. I was overjoyed, took my cam and started flashing lights which would last for 10 plus odd snaps. Other 2 of my friend also came out; we went down to the river stood there for some time and took snaps. Ranger sent one of the guard to wake us up. He said to us that we have to go for safari now else we cannot see animals.
Wow.. and even more surprise was we were allowed to take our car to safari. J Its almost 3 hour’s safari we went in our car into deep jungle. Felt the real jungle silence. The natural animal habitat, they keep running around. It was so silent inside forest. The safari was inexpressible. We had done a regression testing on our car by then. We thanked the ranger, had breakfast and left there around 11:30AM. Again a nice return journey, got our car washed and back to tumkur by evening 7PM.
Unbelievable we had 3 days trip which was not planned even for a day. And it was so cool I was rejuvenated. My mind was completely refreshed.
I was back to office the next Monday, to hear a surprise. I was promoted to next level in the company. J And even the complete month went so cool. There was complete change in the way I started working in office and handling my personal things. I was back to form. Hope the entire year pass by the same way it started. Good thing is I recovered faster than the market. J
