Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Macro substitution in T-SQL
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
VFP Macro substitution in T-SQL
Miscellaneous
Thread ID:
00979670
Message ID:
00979670
Views:
47
What is the equivalent in T-SQL SQL Server to the "&" symbol, VFP macro substitution?.

E.g., I need to do this VFP's example in T-SQL.
lcCond = " name like '%John%' "
SELECT * FROM customers where &lccond
or
lcCond = " invoicenumber > 1056 "
SELECT * FROM invoices where &lccond
How it would be in T-SQL ?

T.I.A.
Next
Reply
Map
View

Click here to load this message in the networking platform