Face

Hi, I've got a column (serialcat) in table (serial) which contains a combination of characters - axzyodu. These characters could be in any order for each row. What I want to do is to display all rows that contain 'o' or 'd' but not 'y' in the serialcat column. So I'd expect back examples of : axdo xuod zoda oax xdu etc..... Any help appreciated. Thanks.

Ok, just figured it out.... Use OR instead of AND : SELECT distinct(LEFT(serial,2)) as serial FROM aircraft where serial like 'W%' or serial like 'X%' or serial like 'Y%'

I've got a table with about 25,000 rows. I was selecting on the serial field using the following : SELECT distinct(LEFT(serial,2)) as serial FROM aircraft This would return the distinct first two characters of the serial. What I'd now like to do is to just select serials that begin with X, W, and Y. But trying SELECT distinct(LEFT(serial,2)) as serial FROM aircraft where serial like ('W%','X%','Z%') or trying SELECT distinct(LEFT(serial,2)) as serial FROM aircraft where serial like 'W%' and serial like 'X%' and serial like 'Y%' don't work. Does anyone have a solution ? Thanks.