Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - like/upper
Message
From
27/05/2007 13:07:43
Naomi Nosonovsky
Wisconsin, United States
 
 
To
27/05/2007 11:07:52
Chaim Halevy
DorYes
Jerusalem, Israel
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL - like/upper
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01228764
Message ID:
01228771
Views:
19
>Hi
>How can I get all the lines that include the capital letter 'F' in anywhere in certain field.
>If I use with 'like' I get also 'f' and I want to get only capital.
>Thank you

Check also http://www.umachandar.com/technical/SQL2000Scripts/Main13.htm
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform