How to write Where clause Position= Developer'sstring

• Swamy Magam

  Ten Centuries

  Points: 1096

  More actions

  March 14, 2008 at 10:39 pm

  #204245

  Hi

  Friends

  I have one table containg two columns like name and position

  it containg two rows like

  Name Position

  scott Developer's

  Tiger Tester's

  i want retrive name where postion is developer's

  select name from table1 where position='developer's'

  it is syntax error how to write this query please help me.

  thanks advance.

  thanks and regards

  swamy

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 15, 2008 at 7:03 am

  #789980

  select name from table1 where position='developer''s'

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Swamy Magam

  Ten Centuries

  Points: 1096

  More actions

  March 15, 2008 at 10:22 pm

  #790108

  Thank u so much

  rbarryyoung

  ok it is Working .

  Regards

  Swamy.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 15, 2008 at 10:54 pm

  #790111

  Glad I could help.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]