Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find a shorter text on a longer column?
Message
From
12/12/2006 13:40:48
Alex Feldstein
Florida, United States
 
 
To
12/12/2006 13:36:24
Borislav Borissov (Online)
Microcomplex
Sofia, Bulgaria
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: How to find a shorter text on a longer column?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01176930
Message ID:
01176941
Views:
8
>>PS: Would SQL syntax be:
>>
>>... " AND trandate LIKE '" + LEFT(myexceldate,10) + "%'"
>>
>
>Where you write this?
>In QA no, if you write it in VFP program or IDE, yes.


VFP of course! :)


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
Reply
Map
View

Click here to load this message in the networking platform