Home » RDBMS Server » Server Administration » Where Field is Part of a list
Where Field is Part of a list [message #372777] Thu, 08 March 2001 13:15 Go to next message
Allan Jagos
Messages: 3
Registered: March 2001
Junior Member
How can I do a WHERE clause to see if a SQL table field is part of a list?

One row's Attachment value is Depo1.txt

WHERE Attachment = 'Depo1.txt,Depo2.txt'

Please respond by e-mail at ajagos@rc.com

Report message to a moderator

Re: Where Field is Part of a list [message #372778 is a reply to message #372777] Thu, 08 March 2001 13:56 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
WHERE Attachment in ('Depo1.txt','Depo2.txt')

Report message to a moderator

Previous Topic: Where Field is Part of a list
Next Topic: Building SQL string and need single quotes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 13:34:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.