wrong in this query ?

• bang725

  Mr or Mrs. 500

  Points: 577

  More actions

  November 5, 2008 at 12:32 pm

  #195457

  select * from universal where name = drill size '9X10'

  wht is wrong in this query ?

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  November 5, 2008 at 12:37 pm

  #894477

  Lack of Quotes.

  select * from universal where name = 'drill size ''9X10'''

  Seth Phelabaum

  ---

  Consistency is only a virtue if you're not a screwup. 😉

  Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]