Should be
column like '%' + ? + '%'
for SQL Server
>Stuck on this as I don't mess with SQL Server much....
>
>The part I'm stuck on is this:
> ?lcname $ UPPER(Address_mess_v15.parishname)
>
>Doing that in a local view is fine --- won't worth with remote view via ODBC to SQL Server of course. I could use SQLEXEC command but I don't know the proper syntax in SQL Server --- anyone help?
>
>SELECT Address_mess_v15.a_pk, Address_mess_v15.capcode_uk,;
> Address_mess_v15.prshdonorn, Address_mess_v15.parishname,;
> Address_mess_v15.address_1, Address_mess_v15.address_2,;
> Address_mess_v15.city, Address_mess_v15.state, Address_mess_v15.zip,;
> Address_mess_v15.parshphone, Address_mess_v15.code_des,;
> Address_mess_v15.looksgood, Address_mess_v15.phys_addr,;
> Address_mess_v15.mail_addr, Address_mess_v15.userid,;
> Address_mess_v15.paltemail;
> FROM ;
> address_mess!address_mess_v15;
> WHERE ( ( ( ( ( Address_mess_v15.looksgood = ( ?lllooksgood1 );
> OR Address_mess_v15.looksgood = ( ?lllooksgood2 ) );
> AND Address_mess_v15.userid = ( ?lcUserId ) );
> AND Address_mess_v15.prshdonorn >= ( ?lnzeroOrNot ) );
> AND ( ?lcname$UPPER(Address_mess_v15.parishname) ) );
> AND ( ?lcphone$UPPER(Address_mess_v15.parshphone) ) );
> ORDER BY Address_mess_v15.a_pk
If it's not broken, fix it until it is.
My Blog