RE: MI-L selecting different objects in the same column

2005-05-31 Thread Jacqui Middleton
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

RE: MI-L selecting different objects in the same column

2005-05-25 Thread Francisco Javier García
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

MI-L selecting different objects in the same column

2005-05-25 Thread Jacqui Middleton
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