Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to do this select in SQL Server?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to do this select in SQL Server?
Divers
Thread ID:
01675733
Message ID:
01675733
Vues:
92
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform