Jacqui,
Try with this
Select * from table where column in ("W", "P", "S", "H", "R", "C", "M", "E",
"F")
Javier Garc�a
-----Mensaje original-----
De: Jacqui Middleton [mailto:[EMAIL PROTECTED]
Enviado el: mi�rcoles, 25 de mayo de 2005 16:43
Para: MapInfo-L
Asunto: MI-L selecting different objects in the same column
Dear List
Does anyone know an SQL command that would allow me to select an array of
different codes within the same column. The codes are W, P, S, H, R, C, M,
E, F.
I realise I can select these individually and then append the tables but I
was hoping there would be a quicker way.
I have tried "and" "or" inverted commas and so on but my syntax is not
working as I want it to.
Cheers
Jacqui Middleton
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16568
