>>My sample was very basic, but more complex then BOL gives.
>>
>>It could be fieldname LIKE 'A%' or fieldname LIKE 'DE%' or fieldname LIKE 'ZEBRA%'
>>
>
>Yes, you combine multiple condition with OR
>
>WHERE fieldname LIKE 'A%' or fieldname LIKE 'DE%' or fieldname LIKE 'ZEBRA%'
>
As much as I don't want that to be the solution. :D
We have to think about how we are going to do this in SQL Server now.
Thanks everyone for the information.
Beth