Danny Ocean (9/11/2013)
Hany Helmy (9/11/2013)
I am really amazed of the 16 people (as of now) who got it right! :w00t:Hope one of them will post a reply explaining how he got the result without throwing an error.
If you only see the like condition and give answer then you will be in those 16 people.
(but i am not in those 16. I gave answer as "0" . :crazy:)
What a horrible question...
Sorry I didn`t get it! the problem in this question is the 11 char value in the Insert statement not the LIKE condition!
I even copy & paste the same batch from the question (JUST TO MAKE SURE I WAS RIGHT NOT DOING THIS ALL THE TIME), got the same error.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant