Some thing funny in SQL ... :Wow:

• tommey152

  Right there with Babe

  Points: 772

  More actions

  February 8, 2012 at 5:34 am

  #391507

  Hi frd's,

  When i am doing my work today i found some thing funny in sql.... by mistake in where condition i ahve given '-' and i Executed successfully and shoen the result of all tables

  Now what i want to know is how it accepts '-' as column name...I want to know how itz working

  select * from t_country_shops

  where '-' like '_' :hehe:

  _______________________________________________________________

  Need help? Help us help you.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 8, 2012 at 5:44 am

  #1444450

  No surprises: it's all documented behaviour.

  You can use any expression as a left or right side of the LIKE operator. Any expression includes a constant, such as '-'.

  -- Gianluca Sartori

• Abhilash T

  Mr or Mrs. 500

  Points: 516

  More actions

  February 8, 2012 at 5:45 am

  #1444451

  Hello

  _ (underscore) means any single character. So '-' like '_' always true

  for ref: http://msdn.microsoft.com/en-us/library/ms179859.aspx

  Thanks