Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do this select in SQL Server?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to do this select in SQL Server?
Miscellaneous
Thread ID:
01675733
Message ID:
01675733
Views:
93
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
Next
Reply
Map
View

Click here to load this message in the networking platform