Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Necesito saber
Message
From
22/08/2004 12:38:08
 
 
To
22/08/2004 12:12:34
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00935323
Message ID:
00935332
Views:
21
>necesito saber si el comodin $ que se usa en el sql que maneja vfp se puede usar en el sql server y como.
>
>el comodin $ "utilizado para buscar un string en una cadena no importa el lugar donde se encuentre"


En T-SQL: "LIKE" y "%" para siginificar multiples caracteres.
SELECT t.title_id, t.title 
FROM authors a, titleauthor ta, titles t
WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
   AND a.au_lname LIKE @au_lname + '%'


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform