>>same, use % and _
>>
>>Like() * becomes %
>>Like() ? becomes _
>>
>>ie
>>
>>like('a*b?c', field1) becomes field1 like 'a%b_c'
>>
>
>Are you sure there is LIKE() function in SQL Server? I do not think so.
I do not think my answer implied that. If it did, sorry
use
where ... ( Field1 like 'a%b_c' )
Gregory