Dear List
Thanks to all those who answered my question. There were several ways of doing
this but the first one that I tried worked and so I used that one ...
Select * from tablename where col_name = any ("W", "P", "S", "H", "R", "C",
"M", "E", "F")
All the best
Jacqui Middleton
o 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
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 trie