Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LIKE operator and search phone without area code
Message
From
21/10/2005 11:33:30
Gregory Adam
Belgium
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: LIKE operator and search phone without area code
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01061088
Message ID:
01061105
Views:
12
>>
>>The ? for the sql LIKE is _ (underscore)
>
>What is the wild char in SQL Server?

same, use % and _

Like() * becomes %
Like() ? becomes _

ie 
like('a*b?c', field1) becomes field1 like 'a%b_c'
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform