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
ICQ 10556 (ya), 254117