Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Angry Unanswered: SQL SELECT Statement

    I am using Microsoft SQL Server 2000. Here is a sample of my code:

    SELECT Class, [Description], [Name], AckTStamp
    FROM Event
    WHERE Badge IN
    (SELECT Badge
    FROM Event
    WHERE [Description] NOT LIKE '%'+'1-1'+'%'
    AND [Description] NOT LIKE '%'+'1-2'+'%'
    AND [Description] NOT LIKE '%'+'1-3'+'%'
    AND [Name] NOT LIKE '%'+'1-1'+'%') <--This statement is not running
    when I execute the query.

    It will work if I place it before the IN statement, but I need it to work inside the IN statement.

    Thanks in advance

  2. #2
    Join Date
    Oct 2002
    I think you would get a response on a strictly SQL Server forum:

Posting Permissions

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