Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    21

    Unanswered: Exclamation mark in field

    I've got a field in one of my tables (sql server db) called Department. One of the entries in this field is 'Director's Office'.... how can I write a query that selects all the entries where the Department= 'Director's Office'... the exclamation mark is causing me problems...

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    try Department= 'Director''s Office'
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Feb 2003
    Posts
    21
    Thanks again Paul!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •