>>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
I think I gave you the same solution <g> I just didn't spell it out :)
If it's not broken, fix it until it is.
My Blog