Syntax to select mutilpe values form column

[awise]

I want to write a query that will return the values where the column data in question is either [= "A" or begins with "S%"] and I'm having difficulty getting this work.

Appreciate any tips and/or suggestions.

Thanks,

zaw

 

[SQLSister]

where col1 = 'A' or col1 like 's%'

Questions about posting. See faq183-874